FIND DUPLICATE RECORD

Oct 19 2014 3:18 AM

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