Thursday 7 April 2016

Find Duplicate Records in a SQL table

SELECT   empno, ename, COUNT (*)
    FROM emp
GROUP BY empno, ename

  HAVING COUNT (*) > 1
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)