0

I just want to have an auto numbering in rank since the data in the table is ordered based from the total.

NAME | TOTAL | RANK

ABC   | 15    | 1

DEF  | 12    | 2

GHI  | 11    | 3
halfer
  • 19,824
  • 17
  • 99
  • 186
arreojn
  • 43
  • 1
  • 1
  • 4
  • 2
    What code generates this? What have you tried? We know your problem, now give us some context that will let us help you. – AlienHoboken May 05 '15 at 22:35
  • Given that this looks like it'll be pulling from e.g. mysql, you should be able to get rank generated with the SQL query. – Jonnix May 05 '15 at 22:36
  • `order by total desc`? But what do you want for rank when two or more records have equal total? – Mark Baker May 05 '15 at 22:36

0 Answers0