The DELETE statement is used to delete rows from a table.

DELETE FROM <table_name> [WHERE <search_condition>]

where:

table_name

specifies the name of the table from which you want to delete rows.

search_condition

is an expression that identifies which rows to delete from the table.

Note: The WHERE clause determines which rows are to be deleted. Without a WHERE clause, all rows of the table are deleted, but the table is left intact. Where clauses can contain subqueries.