Small. Fast. Reliable.
Choose any three.

delete-stmt-limited

WITH RECURSIVE common-table-expression , DELETE FROM qualified-table-name WHERE expr returning-clause ORDER BY ordering-term , LIMIT expr OFFSET expr , expr

Used by:   sql-stmt

References:   common-table-expression   expr   ordering-term   qualified-table-name   returning-clause

See also:   lang_delete.html