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
