delete FROM apns_master WHERE id IN (SELECT id FROM (SELECT id, token, updated, ROW_NUMBER() OVER w AS rnum FROM apns_master WINDOW w AS (PARTITION BY token ORDER BY updated DESC)) t WHERE t.rnum > 1);