17 Nov 2013
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.