Allocating 1st, 2nd, 3rd etc

[Peter Mitchell]

Having sorted records how do I allocated the
top score position 1
second position 2
third position 3
etc

the purpose could be students exam results for example

Hope someone can help, please.

Peter

 

[Guest]

Try this --
SELECT T.Column1, T.Column2, (SELECT COUNT(*)
FROM [YourTable-4] T1
WHERE T1.Column2 <= T.Column2) AS Rank
FROM [YourTable-4] AS T
ORDER BY T.Column2;

If there are two the same it give both the higher rank.