Query problem - top 5 validation

  • Thread starter Thread starter tw
  • Start date Start date
T

tw

Hi,

I have a problem to run a query like this scenario:

i have players in a table who have scored in many matches and i want to take
the 5 latest.

The latest i want to multiply with 1.0 and then after with 0.8, 0.6, 0.4 and
finally 0.2.

playerid round score
1, 10, 122
1, 9, 123
1, 8, 222
1, 7, 333
1, 6, 222

And i want to multiply 122 * 1 + 123*0,8 + 222*0,6 + 333*0,4 + 222*0,2

Even handle if there are only 3 score.

Help, who can i do that in sql?

Regards
TW
 
Are the rounds always consecutive with no gaps? Is the highest numbered
round the "latest"? I expect there is more than one player?
 
Back
Top