How towrite a query for delete duplicate rows from a table

High

[joshmachine]

I have a table called Emp in which empid,Ename are two columns.they having duplicate values also.I want to delete duplicate rows from emp table.how can I write the query for this.

[TheDave]

I don't know about a delete query, but you can use SELECT DISTINCT to get unique records