• delete * from employee where id NOT IN (select min(id) from employee group by employeeno,employeeid)

    This will delete all duplicated records and leave one unduplicated record

    RickO