Iain Adams <aca04iba@shef.ac.uk> wrote:

> I have a table with some ranks in. Firstly I want to order the table
> by the ranks. Then I want to search the new ordered table to find out
> the position of a specific row with a specific rank. Is this possible??

select count(*) from table where rank < (rank of specific person)

--
Pd