Question

What is the SQL Query required to delete all tuples from Stud_table which have Percentage less than 80?​

Answer 1

Answer:

This article on the SQL Delete is a part of the SQL essential series on key statements, functions and operations in SQL Server.

To remove a row from a table is accomplished through a Data Manipulation Language, aka DML statement, using the delete keyword. The SQL delete operation is by far the simplest of all the DML commands. On execution of the delete command, we don’t have to worry about getting any form of data from the table, and we don’t have to worry about working with any data that we get back from the table(s). We just simply tell the database to delete a specific record, and it either does or it doesn’t. It’s that simple.

Note: To learn more about how to use SQL Delete statement, please read The Best Ways to Use SQL Delete Statement in a SQL Table article.