Yes cursors are nasty if you have a lot of data.  But as a quick looping example they are good. 

I usually loop through the table using one of the column identifiers. ...

If if doesn't matter which record you keep you could just create a cursor that includes each duplicate and the number of times the duplicate appears in the table.  Loop...

I really believe that much of this lack in knowledge comes from the advent of MS SQL server.  I am not putting down MS SQL; I have been working...