SQL实战42.删除emp_no重复的记录，只保留最小的id对应的记录

题目

解答

delete t1
from titles_test as t1,titles_test as t2
where t1.emp_no=t2.emp_no
and t1.id>t2.id;

delete from titles_test
where id  in (select a.id 
              from (select *
                           ,row_number() over (partition by emp_no order by id ) as ranking
                     from titles_test) a
              where a.ranking != 1)