Technical Discussion :: Informatica
Home > Technical Interview Q&A > Informatica > Discussion
44 / 94
Write sql query to find the duplicates.
Answer:
TO FIND DUPLICATE IN ORACLE(SQL):
TABLE NAME: EMP.
SELECT * FROM EMP WHERE ROW ID NOT IN ( SELECT MAX(ROWID) FROM EMP GROUP BY COLUMN NAME);
NOTE: COLUMN NAME LIKE EMPID OR NAME AS PER NEED .
Asked In ::
Pintu Kumar
23 Feb, 2019 5:07 AM
TO FIND DUPLICATE IN ORACLE(SQL):
TABLE NAME: EMP.
SELECT * FROM EMP WHERE ROW ID NOT IN ( SELECT MAX(ROWID) FROM EMP GROUP BY COLUMN NAME);
NOTE: COLUMN NAME LIKE EMPID OR NAME AS PER NEED .