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...