Find Duplicate Records in a SQL table

SELECT   empno, ename, COUNT (*)

    FROM emp

GROUP BY empno, ename

  HAVING COUNT (*) > 1