Google News
logo
Oracle - Interview Questions
Write a query to list the duplicate values in an Oracle table.
Written below is a query to list the duplicate values in an Oracle table :
 
SELECT NAME, COUNT (NAME) FROM EMPLOYEE GROUP BY NAME HAVING COUNT (NAME) > 1;

Advertisement