So I'm trying to be jack of all trades on a project, and instead i am
Let's say I have a table of users. Each user has a popularity score
which is a non-negative float.
On each user's homepage I want to display their rank. "Jimbo is
ranked #3" Jimbo has the third highest number in the "popularity"
column (out of all rows) at the moment that I pulled the row out of
Umm...how do I do this? I can think of a really expensive way
involving a giant data load, a sort, and a count, but it's not the
Any ideas? Thanks!