Microsoft interview question

How would you find and remove duplicate rows?