How to Find Duplicate Record

Duplicate Record Check in SQL

SELECT AdmNo, COUNT(AdmNo) AS No
FROM Student
GROUP BY AdmNo
HAVING (COUNT(AdmNo) > 1)