FIND DUPLICATE RECORD
select CustomerMobileNo, transactionid, dup= count (*)from refund group by CustomerMobileNo, TransactionID having COUNT(*)>1
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Nirmal KumarCPosted Oct 20, 2014, 7:57 AM
Wim SturkenboomPosted Oct 19, 2014, 6:23 AM
I guess you have an error
select CustomerMobileNo, transactionid, count (*) as dup from refund group by CustomerMobileNo, TransactionID having COUNT(*)>1
Not tested.