List:Brisbane MySQL Users Group« Previous MessageNext Message »
From:Mark Unwin Date:August 10 2005 12:27am
Subject:Sort by count
View as plain text  
I have a MySQL query such - 
SELECT count(software_name), software_name, software_version from
software WHERE software_name NOT LIKE '%hotfix%' AND
software_no_detect_date = '1111-11-11' group by software_name ORDER BY
software_name LIMIT 1,50

Now, this works fine - sorting by software_name.
How can I sort by count(software_name) ?
I tried using sort count(software_name), just to see, naturally, it
failed.
Any ideas ?

TIA,
Mark Unwin.


*************************************************************************************************
This message and any attachments, or any part
of it is intended solely for the named addressee.  

Reading, printing, distribution, storing, commercialising
or acting on this transmission or any information it contains, by anyone other than the
addressee, is prohibited. If you have received this message in error, please destroy all
copies and notify 
Qld Police Credit Union Ltd on +61 7 3008 4444 or by replying to the sender.

This message may contain legally privileged and
confidential information, and/or copyright material
of QPCU or third parties.

QPCU is not responsible for any changes made
to a document other than those made by QPCU,
or for the effect of the changes on the document's meaning.
You should only re-transmit, distribute or commercialise
the material if you are authorised to do so.

Any views expressed in this message are
those of the individual sender.  You may not rely on this message as advice unless
subsequently confirmed by fax or letter signed by an Officer or Director of QPCU, or 
an Authorised Representative QPCU.

QPCU advises that this e-mail and any attached files should be scanned to detect viruses. 
QPCU accepts no liability for loss or damage (whether caused by negligence or not)
resulting from the use of any attached files.

Information regarding Privacy can be found at the QPCU web site. ( www.qpcu.org.au )

General Advice Warning

Any advice has been prepared without taking into account your particular objectives,
financial situation or needs.  For that reason, before acting on the advice you should
consider the appropriateness of the advice having regard to your own objectives,
financial situation and needs.  Where the advice relates to the acquisition, or possible
acquisition, of a particular financial product, you should obtain a Product Disclosure
Statement relating to the product and consider the Product Disclosure Statement before
making any decision about whether to acquire the product.
*************************************************************************************************

Thread
Sort by countMark Unwin10 Aug
  • [SPAM] Re: Sort by countScott McClintock10 Aug
    • Re: [SPAM] Re: Sort by countArjen Lentz10 Aug
      • Re: [SPAM] Re: Sort by countScott McClintock10 Aug