[Updated] Goldman Sachs Aptitude Test Questions and Answers
Practice List of TCS Digital Coding Questions !!!
Take 50+ FREE!! Online Data Interpretation Mock test to crack any Exams.
Technical Discussion :: Informatica

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 ::

Post Your Answer Here:


Rate This: +0 -0     
Report    

Post Your Reply Here:

Alert me
q4i-reply-your-answer

Report Error

Please Login First Click Here

Most Popular Qs.