List:General Discussion« Previous MessageNext Message »
From:Jason Pruim Date:December 11 2007 4:08pm
Subject:Re: Query help, please..
View as plain text  
On Dec 11, 2007, at 10:46 AM, Rob Wultsch wrote:

> On Dec 11, 2007 8:38 AM, Anders Norrbring <lists@stripped> wrote:
>> I'm looking at a situation I haven't run into before, and I'm a bit
>> puzzled by it.
>>
>> I have this table structure:
>>
>> Table USERS: userid, class
>> Table OBJECT: userid, class, result
>>
>> Now I want to query the database for a certain user's result in a
>> specified class, which is very, very easy. No problems.
>>
>> But, I also want to find out the user's position relative to others
>> depending on the result.
>>
>> So, if the specified user's result is the 9:th best of all of the  
>> users,
>> I want to have a reply from the DB query that say he has position  
>> number 9.
>>
>> I really can't figure out how to do that... Somehow I have to make  
>> MySQL
>> calculate the position based on the value in the result column.
>
> Take a look at http://arjen-lentz.livejournal.com/55083.html . Very
> similar ideas in play, though you also have a join.
>
> The basic idea is that you do a count on the number of users that have
> a lower score.

Is there any reason you wouldn't want to count the people in front of  
you and add 1 to get your place in line? It seems like depending on  
where you are, that may be a shorter number to count :)

But I don't know anything about how to do stuff off of separate tables  
yet still trying to grasp that :)


>
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>

--

Jason Pruim
Raoset Inc.
Technology Manager
MQC Specialist
3251 132nd ave
Holland, MI, 49424
www.raoset.com
japruim@stripped


Thread
Query help, please..Anders Norrbring11 Dec
  • Re: Query help, please..Rob Wultsch11 Dec
    • Re: Query help, please..Jason Pruim11 Dec
  • Re: Query help, please..Peter Brawley11 Dec