select player from
(select player,sum(score) as score
from stats
where roundid = 1
group by player ) dt
order by score
Trådstart#1
Hur gör jag för att sortera efter summan av score distinct per player?
Datat ligger såhär:
player : score : roundid : course
1 : 3 : 1 : 1
1 : 2 : 1 : 1
2 : 4 : 1 : 1
2 : 2 : 1 : 1
4 : 3 : 1 : 1
4 : 1 : 1 : 1
Har kommit såhär långt, men fastar på en where-sats i mitt sub-query.
select distinct player from stats where roundid = 1 and course = 1 order by (select sum( score ) from stats ) asc
Mvh, Vide
