SQL Tutorial
SQL Database
SQL Table
SQL Select
SQL Clause
- sql-where
- sql-and
- sql-or
- sql-with
- sql-as
SQL Order By
SQL Insert
SQL Update
SQL Delete
SQL Join
SQL Keys
Difference
SQL Injection
- sql-injection
Misc
SQL MCQ
- sql-mcq
PL/SQL Tutorial
- pl/sql-tutorial
Interview
- sql-interview
- pl/sql-interview

SQL DELETE ROW

Let us take an example of student.

Original table:

ID	STUDENT _NAME	ADDRESS
001	AJEET MAURYA	GHAZIABAD
002	RAJA KHAN	LUCKNOW
003	RAVI MALIK	DELHI

If you want to delete a student with id 003 from the student_name table, then the SQL DELETE query should be like this:

DELETE FROM student_name
WHERE id = 003;

Resulting table after SQL DELETE query:

ID	STUDENT_NAME	ADDRESS
001	AJEET MAURYA	GHAZIABAD
002	RAJA KHAN	LUCKNOW

Next TopicSQL Delete All rows

Hot Tutorials

Contact US

Email:[email protected]

SQL DELETE ROW

10/30