Member Avatar for Peter_80
Peter_80 0 Newbie Poster

Hi guys ,
I have a tables called “scores”
With the following Fields
AdmNo,Name,
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

Etc

How do I rank?

  • 1 Contributor
  • 0 Replies
  • 222 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.