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?

  1. A.

    the list of names of students with 100 marks in mathematics

  2. B.

    the names of all students of all classes in which at least one student has 100 marks in mathematics

  3. C.

    the names of all students in all classes having 100 marks in mathematics

  4. 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 free

Explore the full course: Nta Ugc Net Paper 2

Loading lesson…