I am unable to understand how this correlated subquery works on the relation
Select Sname from Student s1 where (select count (*) from Student s2 where s1.marks<=s2.marks)=3
I cannot understand the way in which I should comprehend this query starting from inner query. The
count (*) returns the total count of rows in a group but here is it calculating for individual condition satisfied.
Can anyone help in this regard?