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.couse
= 5)
(A) Q.1
(B) Q.2
(C) Both Q.1 and Q.2
(D) Neither Q.1 nor Q.2
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.couse
= 5)
(A) Q.1
(B) Q.2
(C) Both Q.1 and Q.2
(D) Neither Q.1 nor Q.2