题解 | #删除emp_no重复的记录，只保留最小的id对应的记录。#
删除emp_no重复的记录，只保留最小的id对应的记录。
http://www.nowcoder.com/practice/3d92551a6f6d4f1ebde272d20872cf05
考察点：指定条件 删除数据
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)
美团一面810人在聊