CODEWITHSUNDEEP
mysqlgroup-bysql-order-by
Aadi
Aadi

Reputation: 7109

Top ten count using Mysql Query

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

Upvotes: 1

Views: 599

Answers (4)

a'r
a'r

Reputation: 37009

Just add an ORDER BY clause, eg.

ORDER BY count(referrersource)

Upvotes: 0

Michael Pakhantsov
Michael Pakhantsov

Reputation: 25390

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

Upvotes: 1

pharalia
pharalia

Reputation: 709

Adding ORDER BY counts DESC ?

Upvotes: 1

Lieven Keersmaekers
Lieven Keersmaekers

Reputation: 58491

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

Upvotes: 0

Related Questions