SQL:Delete

lastmod 2021-10-08created 2021-10-081 edits

Delete using Select results

DELETE FROM posts WHERE id IN (
    SELECT * FROM (
        SELECT id FROM posts GROUP BY id HAVING ( COUNT(id) > 1 )
    ) AS p
)