Remove Duplicates Postgres

duplicates.sql

/* Single Key Filter  */
SELECT * FROM users
WHERE id IN (SELECT id
              FROM (SELECT id, ROW_NUMBER() 
                    OVER (PARTITION BY email ORDER BY id) AS rnum
                    FROM users) t
              WHERE t.rnum > 1);
             
/* Multi Key Fileter */
SELECT * FROM theme_files
WHERE id IN (SELECT id
             FROM (SELECT id, kind, ROW_NUMBER() 
             OVER (PARTITION BY theme_id, kind ORDER BY id) AS rnum
             FROM theme_files) t
             WHERE t.rnum > 1 AND t.kind = 'mobile_stylesheet');