Delete (SQL)

SQL
The  statement follows the syntax:


 *    table_name [  condition];

Delete rows from table pies where the column flavour equals Lemon Meringue:

Delete rows in trees, if the value of height is smaller than 80.

Delete all rows from mytable:

Delete rows from mytable using a subquery in the where condition:

Delete rows from mytable using a list of values: