Consider the query: SELECT student_name FROM students WHERE class_name =…
PYQ UGC NET 2007
Consider the query:
SELECT student_name
FROM students
WHERE class_name = (SELECT class_name
FROM students
WHERE math_marks = 100);
What will be the output?
- A.
the list of names of students with 100 marks in mathematics
- B.
the names of all students of all classes in which at least one student has 100 marks in mathematics
- C.
the names of all students in all classes having 100 marks in mathematics
- D.
the names and class of all students whose marks in mathematics is 100
Attempted by 252 students.
Sign up free to check your answer
Sign up freeLoading lesson…

