Consider the following SQL query: SELECT name FROM Student WHERE marks ALL (SELECT marks FROM Student WHERE dept='CS'); What does the following SQL query return?

Question

Consider the following SQL query: 
 <SQL> 
 SELECT name  
 FROM Student  
 WHERE marks > ALL (SELECT marks FROM Student WHERE dept='CS'); 
 What does the following SQL query return?

Answer

Students with the highest marks in the CS department.

Answer

Students whose marks are higher than every student in the CS department.

Answer

Students from the CS department only.

Answer

Students with average marks.

Crowdly

Consider the following SQL query: <SQL> SELECT name FROM Student WHERE...

Want instant access to all verified answers on moodle.nottingham.ac.uk?