SQL - DELETE Statement

Use the DELETE statement to delete records from the existing table in the current schema or tables of the schema on which you have the DELETE privilege.

Syntax:

DELETE FROM table_name [WHERE Condition];

This DELETE syntax is valid in all the databases such as SQL Server, Oracle, MySQL, PostgreSQL, SQLite, etc. The WHERE clause is optional.

For the demo purpose, the following Employee table in all the examples here.

You can delete the specific record(s) from the table using the WHERE clause. The following will delete a record from the Employee table where the value of EmpId is 4.

DELETE FROM Employee WHERE EmpId = 4;

Now, the Select * from Employee query will display the following rows.

In the same way, the following will delete all employees from the Employee table whose Salary is more than 20000.

DELETE FROM Employee WHERE Salary > 20000;

Now, the Select * from Employee query will display the following rows.

The following DELETE statement will delete all the records from the Employee table.

DELETE FROM Employee;

Now, the Select * from Employee query will display the empty table.