A DELETE statement in SQL removes records in a relational database management system.

The DELETE statement has the following form:

DELETE FROM table_name [WHERE condition]

Any rows that match the WHERE condition will be removed from the table.

Examples

DELETE FROM mytable WHERE mycol > 100;