ORDER BY ALIAS?

[Guest_imported]

Who can tell me why this query won't work:

SELECT stimm_photo_nr, COUNT(*) AS TotalStimmen
FROM stimmen
GROUP BY stimm_photo_nr
ORDER BY TotalStimmen

Thanks a lot!

 

[karluk]

I don't think you can reference the alias in the order by clause. As a simple work-around, try referencing by position:

SELECT stimm_photo_nr, COUNT(*) AS TotalStimmen
FROM stimmen
GROUP BY stimm_photo_nr
ORDER BY 2

 

[Guest_imported]

Thanks Karluk,

I've tried it and it works, I'm very grateful!