Фев 17, 2020    |      0 комментариев

Удаление дубликатов

DELETE FROM table_name
 WHERE table_name_id IN (
     SELECT
         table_name_id
     FROM (
         SELECT
             table_name_id,
             ROW_NUMBER() OVER w AS rnum
         FROM table_name
         WINDOW w AS (
             PARTITION BY field1, field2
             ORDER BY table_name_id
         )
     ) t
 WHERE t.rnum > 1);

Оставить комментарий