Get a list of top goal scorers

Question

What query should I use if I want a list of top goal scorers. Here is an SQLFiddle.

The result should be:

player_id | goals
1           5
2           2
3           1

`SELECT player_id, SUM(goals) FROM goal GROUP BY player_id;` — Tamil Selvan C, Jun 02 '18 at 06:08
Possible duplicate of [SQL select only rows with max value on a column](https://stackoverflow.com/questions/7745609/sql-select-only-rows-with-max-value-on-a-column) — Venki WAR, Jun 02 '18 at 06:18
I don't understand your sense of 'top'. What do you mean by that? — cdaiga, Jun 02 '18 at 06:25

score 4 · Accepted Answer · edited Jun 02 '18 at 06:23

4

SELECT player_id, sum(goals) goals 
FROM goal GROUP BY player_id 
ORDER BY goals desc;

will help you.

edited Jun 02 '18 at 06:23

cdaiga

answered Jun 02 '18 at 06:07

ssamuel

1 Answers1