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

28 / 108

How to find duplicate records with the number they are duplicated?

Answer:

SELECT Id, count (*) as number_records from table group by id having count (*) > 1.

Asked In :: Syntel Inc.

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.