Cant get the query to work

Question

Try to see which player scored the most goals.

Player_id
Goals.

I tried the following statement:

select player_id, sum(goals) as total
from matchstat
group by player_id
order by total desc limit 1;

But i get the error:

SQL command not properly ended.

Does anyone see the problem with the query?

What RDBMS you are using?? – Mahmoud Gamal Apr 26 '13 at 19:37 — Mahmoud Gamal, Apr 26 '13 at 19:37

Kermit · Answer 1 · 2013-04-26T19:48:42.663

2

Oracle doesn't support the limit clause. Try

SELECT * 
FROM   (SELECT "player_id", 
               SUM("goals") AS total 
        FROM   matchstat 
        GROUP  BY "player_id" 
        ORDER  BY total DESC) a 
WHERE  ROWNUM <= 1

See a demo

edited Apr 26 '13 at 19:48

answered Apr 26 '13 at 19:39

Kermit

33,827
13
85
121

What gave you the clue that OP uses Oracle? – PM 77-1 Apr 26 '13 at 19:52
1

@PM77-1 [`SQL command not properly ended.`](https://www.google.com/search?q=SQL+command+not+properly+ended) – Kermit Apr 26 '13 at 20:05

Cant get the query to work

1 Answers1