Announcement

Announcement Module
Collapse
No announcement yet.

update field with ranking

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • update field with ranking

    Hi, is there an efficient way to update a table with the rank of that row, given a specific order by

    lets say i have

    Table: users
    userid int
    score int
    rank int

    select * from users order by score DESC

    I want to update the rank field, to the corresponding row number in the above query

    Thanks

  • #2
    Reading this article may help :

    http://arjen-lentz.livejournal.com/55083.html

    Comment


    • #3
      Interesting and useful link, thanks!

      Comment

      Working...
      X