FIND DUPLICATE RECORD

Question

select CustomerMobileNo transactionid dup= count (*)from refund group by CustomerMobileNo TransactionID having COUNT(*)>1

Nirmal KumarC · Answer

Answer: This Query get duplicate record count Select shoppername  count (*) as cnt from dbo . sales having count (*) > 1 group by shoppername

Wim Sturkenboom · Answer

And ? I guess you have an error select CustomerMobileNo transactionid count (*) as dup from refund group by CustomerMobileNo TransactionID having COUNT(*)>1 Not tested.