Technical Discussion :: SQL
Home > Freshers > Technical Interview Questions > SQL
87. 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.
SELECT Id, count (*) as number_records from table group by id having count (*) > 1.