DELETE Statement

You can remove existing rows from a table by using the DELETE statement:

DELETE		[FROM]		table

[WHERE				condition];

If no rows are deleted, the message "0 rows deleted" is returned.

DELETE	FROM departments

WHERE	department_name = 'Finance';