Incase if you want to check for all the columns then try this query: delete from emp where rowid not in (select max(rowid) from emp group by...
Separate names with a comma.