List duplicate records

PHOTO EMBED

Fri Sep 23 2022 23:41:42 GMT+0000 (UTC)

Saved by @dhfinch #sql #sqlserver

SELECT DT as TheDate, Count(*) as TheCount
From ManImp
Group By DT 
Having count(*)>1
Order by TheCount DESC
content_copyCOPY

grouped by DT