Question

Swati created a database of her classmates and entered 30 records in it. The teacher has asked her to show the data of those students who have scored less than 50 percent marks. Suggest her the method to apply this criterion.

Answer 1

To retrieve the data of those students who have scored less than 50 percent marks we will use the the SQL SELECT and WHERE CLAUSE statement. It will fetch the data from Swati's database in the form of a result table.

The syntax of the statement is as follows:

SELECT * FROM table_name WHERE marks < 50;

(assuming marks are out of 100)

Answer 2

Answer:

I hope this answer helps you