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
⋅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.