Have you tried using
[code=oracle]
SELECT DISTINCT(empno) FROM Employee
[/code]
Oh, about the deletion part, i'm not really sure, but you should save the results of the 1st query, truncate the table, and insert them back in it again.

Hope it helps...