SQL Delete Query

Basic Query Structure-

DELETE FROM table_name WHERE condition;

 Top 100+ Sql Server Interview Questions

 

 

Note :- Where Condition is mandatory, if misses then all rows of table will be replaced with value.

Demo Query:=

Delete Student
WHERE Student_ID = 1;

See Also- SQL Joins syntax code and query

SQL Query for Item Master with group by and order by and joins