>How to delete duplicate records from the table using SQL query.

I once saw an answer to this but I can't remember what it was. I do know that you can't take the obvious path.

Maybe someone else has an idea.

-Mike