SQL Delete Duplicates Rows
- snippet.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
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)