Top ten count using Mysql Query

Question

Hi

I am using the following mysql query for grouping referrersource.

SELECT referrersource,count(referrersource) as counts 
FROM request_events  
where referrersource!='' 
AND landingpage_collectionid=1 
group by referrersource

Here, I would like to order by my resultset in ascending order.How can I alter my above query.Any suggections please

Answer 1

Add an ORDER BY clause.

SELECT  referrersource
        ,count(referrersource) as counts 
FROM    request_events 
where   referrersource!='' 
        AND landingpage_collectionid=1 
group by 
        referrersource
order by
        2        

Answer 2

Adding ORDER BY counts DESC ?

Answer 3

 SELECT referrersource,count(referrersource) as counts 
 FROM request_events  
 where referrersource!='' 
 AND landingpage_collectionid=1 
 group by referrersource
 ORDER BY 2

Answer 4

Just add an ORDER BY clause, eg.

ORDER BY count(referrersource)