Fetch Duplicate Records

following is the query through which we can fetch duplicate records in our table, let’s take a example of emp table:-

“SELECT name FROM emp GROUP BY name HAVING COUNT(name) > 1”

we will get duplicate names from emp table.

Leave a Reply