Skip to Content
0
Former Member
May 15, 2013 at 04:27 AM

How to retrieve just the duplicate records across multiple columns

35 Views

I have year, Id,dept, first name, last name etc.


I want to retrieve just the records with duplicate employee id and dept. For example -


Id dept

121 4A

121 4A


142 3C

142 3C

131 9Y

131 9Y