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

[EMAIL PROTECTED]
www.nisc.cc




--
Johan Höök, Pythagoras Engineering Group
                - MailTo:[EMAIL PROTECTED]
                - 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



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to