SQL DELETE Statement

Introduction

SQL DELETE Statement is used to delete one or multiple rows from table.

Syntax:
DELETE FROM table_name
WHERE [Condition];

Example : Query using DELETE Statement.
Consider the following table titled 'Clients'.

Client_IDLast_NameFirst_NameContactCountry
1ThomasAlex2400000USA
2CruiseMartin5600000USA
3PanditPrajakta34542892India

1. Write a query to delete row where, Client_ID= 2.

DELETE FROM Clients
WHERE
Client_ID = 2;

The result is shown in the following table.   

Client_IDLast_NameFirst_NameContactCountry
1ThomasAlex2400000USA
3PanditPrajakta34542892India

2. Write a query to delete all rows from the table.

DELETE FROM Clients;

The result is shown in the following table.   

Client_IDLast_NameFirst_NameContactCountry