DELETE
This statement removes rows from a table. To delete rows from a table, the IP must mark support for the DELETE operation.
Syntax
<delete-stmt> ::= DELETE FROM <table_name> [<where-clause>]
<where-clause> ::= WHERE <search-condition>
Example
DELETE FROM emp WHERE deptno=40
