DELETE Statement

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

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

         

               DELETE FROM employees WHERE employee_id = 23
            

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