Consider the table Student (stuid, name, course, marks). Which one of the…
PYQ UGC NET 2013Modified — slightly modified from the official paper; see the solution
Consider the table Student (stuid, name, course, marks). Which one of the following two queries is correct to find the highest marks student in course 5 ? Q.1. Select S.stuid From student S Where not exists (select * from student e where e.course = ‘5’ and e.marks ≥ s.marks) Q.2. Select S.stuid From student S Where s.marks > any (select distinct marks from student S where s.course = 5)
- A.
Q. 1
- B.
Q. 2
- C.
Both Q. 1 and Q. 2
- D.
Neither Q. 1 nor Q. 2
Attempted by 33 students.
Sign up free to check your answer
Sign up freeLoading lesson…

