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
My name is busy
13 de Abril del 2018
busID
Mysql join same table where not in
emp
Aditya
mysql - having
ayushagg31.c
calculate averages for students and levels
1