How to calculate Rank

[Bhutan123]

hi..
can u help me to find rank based on total percentage in Mysql database..

[Luuk]

The function RANK is not a part of MySQL.

A possible solution is to add a counter to your SQL statement like this:

set @a:=0; select @a:=@a+1 as rank, t.* from test t;