Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
sort players by sum of results
DROP TABLE IF EXISTS resulttbl; create table resulttbl (PlayerId int, result int); INSERT INTO resulttbl (Playerid,result) values (1,100),(1, 80),(1, 80),(2,100),(2, 80),(2, 40),(2, 40),(3,160),(3,100),(4,130),(4,130),(5,270); select PlayerId, sum(result) res, group_concat(result) rlist from resulttbl GROUP BY PlayerId ORDER BY sum(result) desc, count(*)
run
|
edit
|
history
|
help
0
ITM_14210069
Sql
Estudiantes
daily score
test wall
mrgzmerch
News Update Denis
Wenfeng Ou
ayushagg31.c
Show databases;