...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
WITH cte AS ( SELECT Id, Field1, Field2, ROW_NUMBER() OVER ( PARTITION BY Field1, Field2 ORDER BY Field1, Field2 ) row_num FROM Table_Name ) DELETE FROM cte WHERE row_num > 1; |
...
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
WITH cte AS ( SELECT Id, Field1, Field2, ROW_NUMBER() OVER ( PARTITION BY Field1, Field2 ORDER BY Field1, Field2 ) row_num FROM Table_Name ) DELETE FROM cte WHERE row_num > 1; |
...