Query to find the Rank or Position

SELECT Name, Marks,

(
SELECT COUNT(*)+1 FROM Student B WHERE A.Marks<B.Marks) AS Rank FROM Student AORDER BY Marks DESC



Output is:

   



To See the Table Values Click here