List:Brisbane MySQL Users Group« Previous MessageNext Message »
From:Scott McClintock Date:August 10 2005 12:26am
Subject: [SPAM] Re: Sort by count
View as plain text  

Two simple solutions:

SELECT count(software_name) software_count, software_name.....
order by software_count


.... order by 1 .....



Mark Unwin wrote:
> 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. ( )
> 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.
> *************************************************************************************************

Scott McClintock                    Email: smcclintock@stripped
General Manager                     Phone: 07 3842 8888
Technical Solutions                   Fax: 07 3842 8899
NetOptions Pty Ltd                    Web:
Brisbane, Australia
............... Simple Solutions in a Complex World ....................
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