The Delete Statement
The general form of the delete statement is:
delete from table
[
where
predicate
];
To delete salesperson Don Marino, we would use the following statement:
delete from salesp
where id = 'DM';
The predicate can specify more than one row if needed. For example, if you want to delete all orders placed before January 1, 1999, you would use:
delete from orderhea
where order_date < '1999-01-01';
If no where clause is specified, the delete is done on the complete table. To remove all rows from the salesperson table, we would use:
delete from salesp;