FIND DUPLICATE RECORD

Rakesh Kumar

Oct 19 2014 3:18 AM

667

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

Answers (2)

Next Recommended Forum

Yesterday's leader

Java, ASP Dot Net

Mumbai (India)

Software engineering, architecture, data.

Perl City (United Kingdom)

Leaderboard

Harshit Pandey

+43

Satya Verma

+153

Harshit Pandey

Saty N

+11

Employer Divyansh

+14

Upcoming Events

Suggested Followers

Vijay

Tahseen Jamil

Harshit Pandey

Vulpes

Dhananjay Kumar