-
Need helping in writing query
Hi friends,
I have a table with cols ( gameid , score , userid ) where gameid is a value from {1-10} represting a unique game . I store only top 10 scores for any game to see the top 10 scorers.
An user when played a game ( with some gameid ) and submits score , i check if the score has place in top 10 records for that game and accordignly update the table.
Now I have to write a query for this scenario.
Given a userid, return all the gameids if his score is in top 3 scores for a gameid
eg output:
gameid position
1 3
6 1
9 2
( user is not in top3 for rest of the games. )
Please reply asap...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|