DELETE

DELETE removes rows from a table.

Source data — Pattern 12: Data Manipulation (DML)

All queries run against the shared employees table (see schema.sql). This pattern introduces core Data Manipulation Language (DML) statements. Topic 79 introduces an employee_updates table to demonstrate the MERGE / UPSERT operation.

DELETE — source table 1

DELETE — source table 2

What it does

DELETE removes rows from a table.

Problem

Delete employees who resigned.

DELETE FROM employees
WHERE status='Resigned';

Result

DELETE — result 1

SQL · Pattern 12 — Data Manipulation (DML)

DELETE

DELETE removes rows from a table.

Source data — Pattern 12: Data Manipulation (DML)

All queries run against the shared employees table (see schema.sql). This pattern introduces core Data Manipulation Language (DML) statements. Topic 79 introduces an employee_updates table to demonstrate the MERGE / UPSERT operation.

DELETE — source table 1

DELETE — source table 2

What it does

DELETE removes rows from a table.

Problem

Delete employees who resigned.

DELETE FROM employees
WHERE status='Resigned';

Result

DELETE — result 1