考察点：指定条件 删除数据
delete from 表名 [where 字段名 = 值]

delete from titles_test where
id in (select id from
(select *,rank()over(partition by emp_no order by id asc ) as n
from titles_test) a
where a.n<>1)