Monday, July 6, 2009

SQL Query returning duplicate records in a database

Use GroupBy, Having clause

SELECT Emp_Name, Emp_ID FROM Emp_Db GROUP BY Emp_Name, Emp_ID HAVING COUNT (*) > 1
Posted by at No comments:
Labels: , , , ,
Subscribe to: Posts (Atom)