Hello,
Imagine that we have a game. Every player get a score based on some work. The score is recorded in a table according to the Name of the player.
FirstName | Score
----------------------------
Alex | 34
Kat | 56
Dru | 17
-----------------------
Now, I need to query table based on Name and to get the place of the player in this game.
For example: which place got Alex? should be 2.
In table can be as many possible players, everybody has his score.
I can't figure out if there is any function which returns the row ID.
Thank you very much
Alex
Imagine that we have a game. Every player get a score based on some work. The score is recorded in a table according to the Name of the player.
FirstName | Score
----------------------------
Alex | 34
Kat | 56
Dru | 17
-----------------------
Now, I need to query table based on Name and to get the place of the player in this game.
For example: which place got Alex? should be 2.
In table can be as many possible players, everybody has his score.
I can't figure out if there is any function which returns the row ID.
Thank you very much
Alex