Application Based Question
Neeta created a database of her classmates and entered 30 records in it. The teacher asked her to
show the data of those students who have scored less than 40% marks. Suggest the method to apply
this criteria.
pls answer it correctly
Answers
Answered by
1
Answer:
The teacher asked her to show data of those students who have scored less than 50% marks.suggest the method to apply ...
78 votes
Answered by
6
answer:
The query in sql will be.
================================
================================
SELECT<NAME<TABLENAME<
WHERE<PERCENTAGE_MARKS>
<40% .
"Here NAME is the column name
containing all students Name.
TABLENAME is the table which
is stored in database having
NAME And PERCENTEGE_MARKS
as attributes Or columns.
PERCENTAGE_MARKS is a column
having percentage of 30 students
in the database.
__________________________________________________________
Similar questions