I want a query such that we can find the nth rank student in a class with respect to their marks. Really appreciated for the reply. Thank you.
Here are two types of answers for your question 1) select mark from student s where n=(select count(*) from student s1 where s1.mark>s.mark);
2) select min(marks) as marks from (select top n * from student order by marks desc) as S1
No one has followed this question yet.