1.

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
Answer» C. the names of all students in all classes having 100 marks in mathematics


Discussion

No Comment Found