booksty 0 Newbie Poster

Hello,
Please I need an efficient algorithm for ranking records in a database.
I know sorting and grouping can produce record ranks, but I want a means of inserting the ranks beside each record as arranged in the table.
For example:

This figures   will rank     
10 -           3
5              5
43             2
78             1
9              4

Thank you for your understanding