
May 3rd, 2015, 03:28 AM
|
Registered User
|
|
Join Date: May 2015
Posts: 1
Time spent in forums: 5 m 26 sec
Reputation Power: 0
|
|
Select top 3 scores
Hi,
I have a db table with competitorid and score.
I want to make a top list that has all competitors 3 best scores. If they only have one it takes one.
1:500
2:200
1:400
1:800
2:300
3:100
1:100
4:50
4:50
4:50
4:50
Would give a the records ordered highest first:
1:1700 (3 best) one omitted
2:500 (2 best)
4:150 (3 best) one omitted
3:100 (1 best)
|