SQL DELETE QUERY


The SQL DELETE Query is used to delete the existing records from a table.

You can use WHERE clause with DELETE query to delete selected rows, otherwise all the records would be deleted.

Syntax

DELETE FROM table_name
WHERE [Condition];

You can combine N number of conditions using AND or OR operators.

Example

idname
11Ashwani
12Sachin
13Deepak
14Soun
DELETE FROM student WHERE name= 'Soun'
Output
idname
11Ashwani
12Sachin
13Deepak

Share this article on