Cheat Sheet logoCheat Sheet Today
SQL DDL and DML/Delete matching rows

Remove rows that match a condition.

Back to sheetBrowse commands
Sign in to save
Section: INSERT, UPDATE, and DELETE

Delete matching rows

sql
sql
DELETE FROM sessions
WHERE expires_at < CURRENT_TIMESTAMP;
Explanation

DELETE removes rows one by one from the table.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing INSERT, UPDATE, and DELETE
Insert one row
Add a single row to a table.
OpenIn sheetsqlsame section
Update matching rows
Modify existing data using a WHERE clause.
OpenIn sheetsqlsame section
Merge or upsert data
Insert new rows and update existing ones in one logical operation.
OpenIn sheetsqlsame section
Insert multiple rows
Add several rows in one statement.
OpenIn sheetsqlsame section
Insert from select
Populate a table using query results.
OpenIn sheetsqlsame section
Create table
Define a new table with columns and constraints.
OpenIn sheetsql