SQL DELETE statement allows you to delete a single record or multiple records from a table or an entire records in a table.
The syntax for the SQL DELETE statement is:
For Deleting an entire records in a table
DELETE FROM table_name WHERE;
Delete only specific records from a table, For this purpose we can use WHERE clause and can only delete selected records.
DELETE FROM table_name WHERE [condition];
In WHERE clause we can use AND, OR conditions.