Write a query to find duplicate rows In table?

1.	Write a query to find duplicate rows In table?
Answer» SELECT std_id, COUNT(std_id) as cnt FROM STUDENT GROUP by std_id having cnt > 1

Discussion