Welcome to the new platform of Programmers Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use it's exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.
Query To Retrieve Duplicate Records
I am using SQL Server 2000 as my database. I need a query for the following purpose.
I have two tables Emp and Emp_Name .
Emp Table has fields like Emp_id (integer),DOB(date),PhoneNo(varchar),.......
Emp_Name has fields like Emp_id (integer),lastname,firstname,middlename,.....
I don't have any Primary key and Foreign Key relation ship between these two tables.
I want to get all the Duplicate Employee related records . ie , I want to get employee details who has same first name , last name , middle name and DOB.
Will a single query do the above job ? please give a exact query for the above one.
Thanks In Advance.