How To Use Where Condition With Delete Query In SQL

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

Yasin Panwala

Yasin Panwala is a Web Developer and Author at TheCodeHubs. He has experience in Web Developing and Designing and also in Writing. He has got his skills in working on technologies like .NET Core, ADO.NET, AJAX, Angular, AngularJS, ASP.NET, ASP.NET MVC, Bootstrap, C#, CSS, Entity Framework, Express.js, GraphQL, HTML, JavaScript, JQuery, JSON, LINQ, Microsoft Office, MongoDB, MySQL, Node.js, PostgreSQL, SQL, SQL Server, TypeORM, TypeScript, Visual Basic .NET, Web API. He also got his skills in working with different integration and some known versioning tools. He is always ready to learn new things and he always tries his best on tasks that are assigned to him and gives the best possible outputs.