Removing Data – DELETE Statement

The Delete statement removes the rows from the table. The Delete command has a DELETE FROM clause and an optional WHERE clause. A DELETE FROM statement names the table on that the deletion operation is to be performed and the WHERE clause specifies the condition.

Syntax:

DELETE FROM <tablename> [WHERE <condition>]

Example

DELETE FROM employee2 WHERE deptno=20;

This statement erased all the records from the employee2 table for that the deptno 20. The subsequent example removes all the records are from the table.

Example:

DELETE FROM employee2;