sql query

Question

Comments

your assumption is wrong try that gate 2005 question and come to this. you will understand better.

and (a,1) count is 3, it means that there are 3 rows which are having greater salary then a.

---

@Shubhgupta @MiNiPanda MY MISTAKE :/

I AM NOT THINKING ABOUT COORELATED RELATION

---

@minipanda

we can write it in that form also... Even in C also we can write in that way...

coming to co-related query, form a sample table which can give different result for different options, then run the query on that table... This is a simple method ( as per my opinion )

Answer 1

C. 

This is a correlated nested query. Where inner query gives a count of employee having more salary than the employee in outer query and 2 checks that only 2 people have more salary than him.