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