bing
Flat 10% & upto 50% off + 10% Cashback + Free additional Courses. Hurry up
×
UPTO
50%
OFF!
Intellipaat
Intellipaat
  • Live Instructor-led Classes
  • Expert Education
  • 24*7 Support
  • Flexible Schedule

How to delete the record from the table in SQL

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.

Syntax:

DELETE from table-name

WHERE [condition];

‘OR’

To delete whole record from the table

DELETE from table-name;

Example:

If we want to delete a student details whose roll no. is 15.

DELETE from Student-details

WHERE Roll-no=15;
Previous Next

Download Interview Questions asked by top MNCs in 2018?

Learn SQL in 16 hrs from experts



"0 Responses on DELETE Query"

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.
top

Sales Offer

Sign Up or Login to view the Free DELETE Query.