al9 — 2010-10-28T05:59:43-04:00 — #1
I have to choose artists with biggest number of songs from DB.
To count the number of songs for each artist I use this query:
SELECT artis, COUNT(song) FROM lyric GROUP BY artis LIMIT 0,100;
I wonder is it possible to sort results by number of songs in the same MySQL query? Or I should use other methods to sort results?
r937 — 2010-10-28T06:19:06-04:00 — #2
of course it's possible
, COUNT(*) <font color='"Blue"'>AS songs</font> FROM lyric
BY <font color='"blue"'>songs </font>DESC LIMIT 0,100
al9 — 2010-10-28T08:08:26-04:00 — #3
Thanks a LOT.