delete from titles_test 
where id  not in(
select id
from (

select * ,row_number()over(partition by emp_no order by id asc) rn
from titles_test
)t 
where rn =1

)