主要工具: Linux, Python, SQL
WITH cte AS ( SELECT c1, c2, row_number() OVER(PARTITION BY c1, c2 ORDER BY c1) AS [rn] FROM tableName ) delete cte WHERE [rn] > 1
Post a Comment
No comments:
Post a Comment