需要使用row_number（）从表中删除重复的记录

需要使用row_number（）从表中删除重复的记录

WITH cte AS(    SELECt ROW_NUMBER() OVER(PARTITION by ID ORDER BY name) AS Row    FROM test)DELETe FROM cteWHERe Row > 1