Saturday, 13 June 2015

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 smarks > 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

Answer  A

No comments:

Post a Comment

Note: only a member of this blog may post a comment.