SQL DELETE Statement

DELETE statement in SQL is used to delete records from Tables.
You can either DELETE a single record, or multiple records in a table.
You can specify which records to DELETE via a WHERE clause.
Syntax of DELETE Statement is as follows:

DELETE FROM TABLENAME WHERE condition

Imagine we have table called CUSTOMER, with the following data:

Rambo

Robert

Belgium

Mugambo

Kichidi

Norway

Nagashekar

Rao

India

Scenario 1: Delete a record in Customer table. First name: Rambo
We can use a DELETE statement as follows.

DELETE FROM Customer WHERE FIRSTNAME='Rambo'

Result: 1 Row deleted. Table contents:

Mugambo

Kichidi

Norway

Nagashekar

Rao

India

In the above DELETE statement, we deleted the record where FIRSTNAME is Rambo.

Scenario 2: Delete all records from Customer table
We can use a DELETE statement as follows.

DELETE * FROM CUSTOMER

Result: 2 Rows deleted. Table contents:

Note: * is optional.