delete from C_CHAR_SEQUENCE WHERE id in (select id from (
select id ,ROW_NUMBER() over(partition by PRIORITY,SEQUENCE,land, SOURCE,MATERIAL,char order by changedate desc) numNo from C_CHAR_SEQUENCE with(nolock)
) aaa
where numno > 1
)
原文：https://www.cnblogs.com/watchfluture/p/9047192.html