SQL 2023 · Changing data

Delete rows

Remove the rows that match.

DELETE FROM sessions WHERE expires_at < CURRENT_TIMESTAMP;

Caution: Without a WHERE clause, every row is deleted. Run it as a SELECT first to see which rows match.

Official SQL 2023 documentation

More changing data commands

All changing data commands · SQL 2023 cheatsheet

Was this page helpful?