ORDER BY ASC DESC & LIMIT

Question

I would to do something such as:

SELECT Position INTO lastPosition FROM ranking 
ORDER BY ranking.Time DESC ranking.Position DESC LIMIT 1;

but i get this error:

and:

The goal is to select last row (limit 1) of ranking ordered by descendent position and ascendent time.

The problem was a missing comma after the first DESC, the correct statement is

SELECT Position INTO lastPosition FROM ranking 
ORDER BY ranking.Time DESC, ranking.Position DESC LIMIT 1;

as noticed @Solarflare.

Around here, you get minus one for phrases like "doesn't work", so I'll start the ball rolling... — Strawberry, Sep 07 '16 at 08:53
What exactly do you mean by that it does not work? What's the error message or unexpected behaviour you encounter? — Shadow, Sep 07 '16 at 08:56
Is the above statement inside a stored proc / function or outside of it? — Shadow, Sep 07 '16 at 09:06
You are missing a comma after the first `desc`. And what do you want to get? The last row? Then you have to reverse your order and take the first. — Solarflare, Sep 07 '16 at 09:13
Yes, the problem was the missing comma. Now it's okay with: `... ORDER BY ranking.Time DESC, ranking.Position DESC LIMIT 1;` — shogitai, Sep 07 '16 at 09:15
You could just delete the question as it is not going anywhere unless you self answer it — Drew, Sep 07 '16 at 12:38

score 1 · Answer 1 · edited May 23 '17 at 12:33

1

The problem was a missing comma after the first DESC, the correct statement is

SELECT Position INTO lastPosition FROM ranking 
ORDER BY ranking.Time DESC, ranking.Position DESC LIMIT 1;

as noticed by @Solarflare.

edited May 23 '17 at 12:33

Community

answered Sep 07 '16 at 13:31

shogitai

1 Answers1