Hi guys ,
I have a tables called “scores”
With the following Fields
Maths,English,Biology ,Avg
Am loading this data to my datagridview using select

“Select * from scores order by Avg Desc”

Which works fine

my question is how do i get the rank of every student from the datagridview in the form of

Adm Name Maths Eng Biology Avg. rank

  1. Peter. 80. 60. 70. 75. 1
  2. Alex. 20. 20. 20. 20. 2


How do I rank?