Show pageOld revisionsBacklinksBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. # SQL Delete Duplicates Rows ```sql With rn AS ( select ROW_NUMBER() over (partition by id) as rn, * from TABLE where condition=1 ), id_list as ( select id from rn where rn.rn > 1 ) delete from TABLE where id in (select id from id_list) ``` open/sql-delete-duplicate-rows.txt Last modified: 2024/10/05 06:15by 127.0.0.1