DELETE Query

The DELETE Query in T-SQL is used to delete the existing records, which we want to remove from the table. We use the WHERE clause with DELETE command to delete the rows that we have selected to delete. Otherwise the record is deleted.

Syntax:-

DELETE FROM table_name
WHERE [condition];

We combine N number of condition using the AND or OR operators.

Example:

Consider the EMPLOYEES table which has the following records-

ID	Name	AGE	ADDRESS	Salary
001	Rahul	23	Kota	20000.00
002	Clinton	22	Mumbai	15000.00
003	Kamal	31	Delhi	25000.00
004	Chitra	28	Kanyakumari	65000.00
005	Santanu	26	Madhya Pradesh	38500.00
006	Savitri	24	Bhopal	4500.00
007	Manii	30	Indonesia	15000.00

Example 1:

Below command is an example of DELETE an EMPLOYEES record, whose ID is 006-

DELETE FROM EMPLOYEES
WHERE ID = 006;

EMPLOYEES table will have the below records:

ID	Name	AGE	ADDRESS	Salary
001	Rahul	23	Kota	20000.00
002	Clinton	22	Mumbai	15000.00
003	Kamal	31	Delhi	25000.00
004	Chitra	28	Kanyakumari	65000.00
005	Santanu	26	Madhya Pradesh	38500.00
007	Manii	30	Indonesia	15000.00

Example 2-

Below command is an example of DELETE an EMPLOYEES record, who's Name is RAHUL-

DELETE FROM EMPLOYEES
WHERE NAME = RAHUL;

Output:

ID	Name	AGE	ADDRESS	Salary
002	Clinton	22	Mumbai	15000.00
003	Kamal	31	Delhi	25000.00
004	Chitra	28	Kanyakumari	65000.00
005	Santanu	26	Madhya Pradesh	38500.00
007	Manii	30	Indonesia	15000.00