Introduction

In this article, we will learn how to write a SQL delete query with Where condition.

To delete the existing data in the SQL DELETE statement is used.

To filter records and extract only those records that fulfill a specified condition, The WHERE clause is used.

Syntax

DELETE FROM TABLE_NAME WHERE condition;

Example

The subsequent statement would delete only those records that fulfill a specified condition in the Article table.

DELETE FROM Article WHERE Id = 'A2';

 

Also, check How To Write Delete Query In SQL