 Sql query for sorting the output in the descending order
Select distinct b.contributor, blogaddress,count(b.contentid) RecipeCount,isnull(c.cnt,0) Other
from weblogs.dbo.blogentries b left outer join (select contributor , count(*) cnt from weblogs.dbo.blogentries where category='food' and subcategory = 'others' group by contributor) c
on b.contributor = c.contributor
where category='food' and subcategory<>'others' and destid>0
group by b.contributor,blogaddress,cnt
When I execute the above query I get the below given output which is correct as per the data
Contributor Baseaddress Recipecnt others
Uma Balakumar umabalakumar.sulekha.com 81 0
Uma Shogalingam umashogalingam.sulekha.com 136 1
umaudayshanker umaudayshanker.sulekha.com 1 0
umpc umpc.sulekha.com 2 1
uropinion uropinion.sulekha.com 0 0
ushasuryamani ushasuryamani.sulekha.com 19 2
I want an sql query which will display the top bloggers, sorting the output data in the descending order. The result should be displayed as:
Uma Shogalingam umashogalingam.sulekha.com 136 1
Uma Balakumar umabalakumar.sulekha.com 81 0
ushasuryamani ushasuryamani.sulekha.com 19 2
umpc umpc.sulekha.com 2 1
umaudayshanker umaudayshanker.sulekha.com 1 0
uropinion uropinion.sulekha.com 0 0
 | 
