DELETE Statement

The DELETE statement allows deleting selected rows from a database table.

Syntax Syntax

<delete statement> ::= DELETE FROM <table name>
                                     ( <where clause> )?

End of the code.

Example Example

DELETE FROM employees WHERE employee_id = 23

End of the code.

Deleting Rows from a Table. All rows are witch fulfill the condition employee_id=23 are deleted from the table employees.