List:General Discussion« Previous MessageNext Message »
From:Johan Hook Date:May 12 2004 3:52pm
Subject:Re: ORDER BY Question
View as plain text  
Hi Dirk,
you should be able to just add on "ORDER BY Count" after your groub clause.

/Johan

Dirk Bremer (NISC) wrote:

> The following query produces the following results:
> 
> select job_coop as 'Job/Coop', count(*) as Count from queue group by
> job_coop;
-- snip
> 
> Is there a way to use the ORDER BY clause to order the results by the
> numeric value of the count(*), i.e. so that the results would be sorted by
> the result of the count(*)?
> 
> Dirk Bremer - Systems Programmer II - ESS/AMS  - NISC St. Peters
> USA Central Time Zone
> 636-922-9158 ext. 8652 fax 636-447-4471
> 
> dirk.bremer@stripped
> www.nisc.cc
> 
> 


-- 
Johan Höök, Pythagoras Engineering Group
		- MailTo:johan.hook@stripped
		- http://www.pythagoras.se
Pythagoras AB, Stormbyv. 2-4, SE-163 55 SPÅNGA, Sweden
Phone: +46 8 760 00 10 Fax: +46 8 761 22 77
Thread
• ORDER BY QuestionDirk Bremer \(NISC\)12 May
  • Re: ORDER BY QuestionMichael Kruckenberg12 May
  • Re: ORDER BY Question(Johan Hook)12 May
  • Re: ORDER BY QuestionRhino12 May
  • Re: ORDER BY QuestionDirk Bremer \(NISC\)12 May
    • Re: ORDER BY Question(Johan Hook)13 May