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 -