Tag archive
Commands grouped around the same concept, pattern, or recurring problem.
Remove matching rows with `DELETE`, then query the remaining table contents.
Remove rows from one table when a matching row exists in another table using a subquery.