UGC NET CSE | December 2013 | Part 3 | Question: 58

Question

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 exist (select * from student e where e course ='5' and e marks $\geq$ 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 1

1. Select S.stuid from student S where not exist (select * from student e where e course ='5' and e marks ≥ s marks)  = false

Select S.stuid from student S where not exist (select * from student e where e course ='5' and     e marks > s marks) = correct

Q.2. select S.stuid From student S where s.marks > any (select distinct marks from student S where s.course =5)  =  false

select S.stuid From student S where s.marks >All (select distinct marks from student S where s.course =5) =  correct

Ans is D

Comments

@srestha check this.

---

@Anirudh yes both false

But Q1 will be emarks<smarks

Q2. select s.stu.id From student S where s.marks where not exists> any (select distinct marks from student S where s.course =5)

correct me if wrong

---

we are select smarks so s marks is not less then any other then inner query is empty ans will be selected.

for Q2: select s.stu.id From student S where s.marks where not exists> any (select distinct marks from student S where s.course =5)

m not confirm since 1st time saw not exist > any