Re: Best way to sort?

yes, Is the column number on select statement. You could use alias too: SELECT person_name, count(*) count FROM table_name GROUP BY person_name ORDER BY count DESC ----- Original Message ----- From: "Angelo Zanetti" <binc2@ctech.ac.za> To: "Raúl Castro" <ora7@cdmb.gov.co>; <php-general@lists.php.net> Sent: Friday, June 04, 2004 2:20 AM Subject: RE: [PHP] Best way to sort? > what is the 2? in the order by statement mean? > thanks > > -----Original Message----- > From: Raúl Castro [mailto:ora7@cdmb.gov.co] > Sent: Thursday, June 03, 2004 6:20 PM > To: php-general@lists.php.net > Subject: Re: [PHP] Best way to sort? > > > The best way is: > > SELECT person_name, count(*) > FROM table_name > GROUP BY person_name > ORDER BY 2 DESC > > > ----- Original Message ----- > From: "Daniel Clark" <dclark@nwlink.com> > To: "Brian Dunning" <brian@briandunning.com> > Cc: <php-general@lists.php.net> > Sent: Thursday, June 03, 2004 10:30 AM > Subject: Re: [PHP] Best way to sort? > > > > SELECT DISTINCT person_name, count(*) > > FROM table_name > > GROUP BY person_name > > ORDER BY 2 DESC > > > > > I'm not sure if this is a complex SQL query or a PHP array sorting > > > thing, but what's the best way to take this data: > > > > > > Tom > > > Greg > > > Brian > > > Tom > > > Brian > > > Tom > > > > > > And return the following results, sorted by number of records: > > > > > > Tom - 3 > > > Brian - 2 > > > Greg - 1 > > > > > > Any thoughts? > > > > > > -- > > > PHP General Mailing List (http://www.php.net/) > > > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, visit: http://www.php.net/unsub.php > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -------------------------------------------------------------------- > Disclaimer > This e-mail transmission contains confidential information, > which is the property of the sender. > The information in this e-mail or attachments thereto is > intended for the attention and use only of the addressee. > Should you have received this e-mail in error, please delete > and destroy it and any attachments thereto immediately. > Under no circumstances will the Cape Technikon or the sender > of this e-mail be liable to any party for any direct, indirect, > special or other consequential damages for any use of this e-mail. > For the detailed e-mail disclaimer please refer to > http://www.ctech.ac.za/polic or call +27 (0)21 460 3911