+----+-----------+-------+ | id | name | price | +----+-----------+-------+ | 1 | りんご | 100 | | 2 | りんご | 200 | | 3 | バナナ | 250 | | 4 | バナナ | 250 | ←削除したい | 5 | ぶどう | 100 | | 6 | ぶどう | 100 | ←削除したい | 7 | ぶどう | 120 | +----+-----------+-------+ DELETE FROM fruits WHERE id NOT IN (SELECT min_id from (SELECT MIN(id) AS min_id FROM fruits GROUP BY name, price) AS tmp); +----+-----------+-------+ | id |