How to Find Duplicate Records in sql query

How to Find Duplicate Records in sql query

SELECT CARD_NO_ENCPT FROM `xxxxxxxxxxxxx`;
WHERE pos_dt=’2017-01-31′
GROUP BY CARD_NO_ENCPT
HAVING count(1)>1

Information from:

http://www.tech-recipes.com/rx/49959/finding-duplicate-records-using-group-by-in-sql-server/

Like

workdiary has written 200 articles