Display duplicate rows in a table

Question

How to Display duplicate rows in a table?

Shankar M · Answer

Hi Sharad You can get the entire duplicate row details for the columns being compared something like this SELECT * FROM EMP A WHERE EXISTS (SELECT 1 FROM EMP WHERE empno = A.empno AND ROWID Thanks Shankar

Manish Dwivedi · Answer

This query for finding duplicates in a table. Suppose you want to find all Names in a table that exist more than once: SELECT UserName COUNT(UserName) AS TotalOccurrences FROM users GROUP BY UserName HAVING ( COUNT(UserName) > 1 )