Deleting rows

ASA Getting Started
Updating the Database

Deleting rows

Sometimes you will want to remove rows from a table. Suppose Rodrigo Guevara (employee ID 249) leaves the company. The following statement deletes Rodrigo Guevara from the employee table.

DELETE
FROM employee
WHERE emp_id = 249

With UPDATE and DELETE, the search condition can be as complicated as you need. For example, if the employee table is being reorganized, the following statement removes from the employee table all male employees hired between March 3, 1989 and March 3, 1990.

DELETE
FROM employee
WHERE sex = 'm'
    AND start_date BETWEEN '1988-03-03'
    AND '1989-03-03'

You can also delete rows from database tables from the Interactive SQL result set.

For more information, see Editing table values in Interactive SQL.

Since you have made changes to the database that you do not want to keep, you should undo the changes as follows:

ROLLBACK