DELETE FROM

The DELETE statement is used to delete given row or rows or all rows in a table or view.

DELETE [*] FROM table_name [WHERE column_name = some_value];