Query To Find Duplicate Rows In Table?

1.	Query To Find Duplicate Rows In Table?
Answer» SELECT std_id, COUNT(std_id) as cnt FROM STUDENT GROUP by std_id having cnt &GT; 1 SELECT std_id, COUNT(std_id) as cnt FROM Student GROUP by std_id having cnt > 1

Answer»

SELECT std_id, COUNT(std_id) as cnt FROM STUDENT GROUP by std_id having cnt &GT; 1

SELECT std_id, COUNT(std_id) as cnt FROM Student GROUP by std_id having cnt > 1

Discussion