Connecting Tech Pros Worldwide Help | Site Map

Sql query for sorting the output in the descending order

 
LinkBack Thread Tools Search this Thread
  #1  
Old October 7th, 2008, 06:38 AM
Newbie
 
Join Date: Sep 2008
Posts: 17
Default 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
Reply
  #2  
Old October 7th, 2008, 09:36 AM
ck9663's Avatar
Expert
 
Join Date: Jun 2007
Posts: 1,809
Default

use the ordinal position of the field

ORDER BY 4 DESC will sort the result set using the fourth column in descending order.

-- CK
Reply
Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search


Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.