[RESOLVED] ORDER BY question ...

[Avihai]

Hi all,

I have this code:

SELECT name, COUNT(userid) AS most FROM table WHERE published=1 GROUP BY userid


and I want to ORDER BY the result of most after being counted, any ideas?

Thanks,
Avihai

[chazzy]

did you try just putting the order by clause on it?


SELECT name, COUNT(userid) AS most FROM table WHERE published=1 GROUP BY userid ORDER BY most;

[Avihai]

Very interesting ... I did it before I posted and it didn't work, but after it did. Anyhow thanks for taking the time to answer :-)