It is used to delete the record from the table. To delete the particular row from the table we use WHERE clause with the DELETE statement.
DELETE from table_name WHERE [condition]; ‘OR’ To delete whole record from the table DELETE from table_name;
If we want to delete a student details whose roll no. is 15.
DELETE from Student_details WHERE Roll_no=15;Previous Next
Learn SQL in 16 hrs from experts