Answers

FIND DUPLICATE RECORD

Rakesh Kumar

10y

688

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

Answers (2)

Forum Statistics

Please welcome our newest member Achievers It.
2,381,653 users have contributed to 122,515 threads and 389,030
In the past 24 hours, we have 1 new threads, 5 new posts, and 0 new users.
In last week, the most popular thread is 'What's the difference between a DataTable and a DataReader?'.

Upcoming Events

View all

Live

How Gen AI is Reshaping Content, Code, and Commerce