Cara mencari data duplikat query sql server

Assalamu'alaikum wr wb
Kali in saya akan share bagaimana Cara mencari data duplikat di query sql server.
Berikut ini contoh querynya.
----------------------------------------------------------------------------------
Select shoppername, a, b, amountpayed, item, count(*) as cnt
from dbo.sales
group by shoppername, a, b, amountpayed, item
having count(*) > 1
----------------------------------------------------------------------------------
Semoga bermanfaat.
http://pangeran-it.blogspot.co.id/