Question

Subhani created a database of her classmates and entered 25 records in it ? Her teacher asked her to show the data of those students who have failed? ( Passing marks is 45 percent). Suggest how can u apply this criteria? Please give the answer!!!​

Answer 1

The query in sql will be

SELECT <NAME> FROM <TABLENAME> WHERE <PERCENTAGE_MARKS> <50;

Here NAME is the column name containing all students name. TABLENAME is the table which is stored in database having NAME and PERCENTAGE_MARKS as attributes or columns. PERCENTAGE_MARKS is a column having percentage of all 30 students in the database.