Question

to delete the record of those students who are having marks
less than 30 ​

Answer 1

Answer:

Delete query is used to delete records from the table. This query is used along with some condition to selectively delete records from the table. To delete all the records from the table we can use truncate command like this

This will remove all the records from the table. This is one way of deleting all the records from a table. Now let us try to delete records based on some selection. Now let us delete records of the students who has got mark less than 30. Here we are selectively deleting the records so we have to use WHERE clause to match the selection.

This will delete records for which mark is less than 30.

I HOPE IT HELPS

Answer 2

Answer:

Delete query is used to delete records from the table. This query is used along with some condition to selectively delete records from the table. To delete all the records from the table we can use truncate command like this.