Swathi created a database of her classmates and enter 30 records in it. The teacher asked her to show data of those students who have scored less than 50% marks.suggest the method to apply these criteria.
Answers
Answered by
240
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.
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.
Answered by
69
Explanation:
hope it helps you please mark me as brainliest
Attachments:
Similar questions
Biology,
7 months ago
CBSE BOARD X,
7 months ago
English,
7 months ago
Physics,
1 year ago
Math,
1 year ago