1.

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.stuidFrom student SWhere not exists(select * from student e where e course = '5' and e marks = s marks)Q.2. Select s.stu.idFrom student SWhere s · marks u003e 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» C. Both Q. 1 and Q. 2


Discussion

No Comment Found