Javatpoint Logo

91-9990449935

 0120-4256464

SQL DELETE ROW

Let us take an example of student.

Original table:

IDSTUDENT _NAMEADDRESS
001AJEET MAURYAGHAZIABAD
002RAJA KHANLUCKNOW
003RAVI MALIKDELHI

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

Resulting table after SQL DELETE query:

IDSTUDENT_NAMEADDRESS
001AJEET MAURYAGHAZIABAD
002RAJA KHANLUCKNOW