What Is SQL DELETE Statement And How To Use

The SQL DELETE statement allows you to delete a single record or multiple records from a table.

The syntax for the SQL DELETE statement is:

DELETE FROM table WHERE predicates;

Simple example:

DELETE FROM Employee WHERE emp_name = 'BOB';

This SQL DELETE statement would Delete all records from the employees table where emp_name is BOB.