Unanswered: Need to delete duplicate rows and keep two rows
I have a table which has duplicate rows. I need to delete the duplicate rows but I can not simply delete all the the duplicate rows and keep only one copy of the record. My requirment is such that, I need to delete Duplicate rows but need to keep two duplicate rows.
For example If I have a table Employee with the records as shown below.