删除emp_no重复的记录，只保留最小的id对应的记录

不知这种写法是否有特殊情况，请佬们指正！

delete from
    titles_test
where
    id in (
        select
            id
        from
            (
                select
                    id,
                    ROW_NUMBER() over (
                        PARTITION by
                            emp_no
                        ORDER BY
                            id
                    ) as `rank`
                from
                    titles_test
            ) t1
        where
            `rank` >= 2
    )