delete from "tablename"
where "columnname" OPERATOR "value" [and|or "column" OPERATOR "value"];
[ ] = optional

Examples:

delete from employee;

Note: 如果你沒有指定where 子句，那麼全部的紀錄都會被刪除。

delete from employee
where lastname = 'May';


delete from employee
where firstname = 'Mike' or firstname = 'Eric';

"delete from" 接著資料表名, 再接著是條件式判斷，沒有條件式，則全部紀錄會被刪除。

Delete 練習_
(use the select statement to verify your deletes):

1 Jonie Weber-Williams 已離職，請刪除他的紀錄資料。
2 由於預算縮減，把公司中那些超過70000 元以上的人員刪除。

參考解答

SQL Interpreter: