Ques 58-III-D-13

58. 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.stu.id
       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

ANS-(D)

Description is coming soon---