4.1. Syntax

To delete records from a table, use the following syntax:

DELETE FROM "tablename"
WHERE "columnname" OPERATOR "value"
[AND|OR "columnname" OPERATOR "value"];

Note: The WHERE clause is optional. If omitted, all records will be deleted.

4.2.1. Example 1: Delete all records

DELETE FROM employee;

If you leave off the WHERE clause, all records will be deleted!

4.2.2. Example 2: Delete specific records

DELETE FROM employee
WHERE lastname = 'May';

DELETE FROM employee
WHERE firstname = 'Mike' OR firstname = 'Eric';

4.4.1. Answer 1

Jonie Weber-Williams just quit, remove her record from the table:

DELETE FROM myemployees_ts0211
WHERE lastname = 'Weber-Williams';

4.4.2. Answer 2

It's time for budget cuts. Remove all employees who are making over 70000 dollars:

DELETE FROM myemployees_ts0211
WHERE salary > 70000;

4.4.3. Answer 3

Create at least two of your own DELETE statements:

-- Delete employees from the "Sales" department
DELETE FROM myemployees_ts0211
WHERE department = 'Sales';

-- Delete employees hired before the year 2000
DELETE FROM myemployees_ts0211
WHERE hire_date < '2000-01-01';

4.4.4. Answer 4

Delete all records from the table:

DELETE FROM myemployees_ts0211;