MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:DL Neil Date:January 26 2002 3:34pm
Subject:Re: Selecting the row with largest number in a column
View as plain text  
Thanks for that BB.

How large was the test table (rows and cols)?

Did you test the alternative expressions by conducting a number of queries (to note the
impact of any caching)?

Did putting an index on age have any impact? (I would expect ORDER BY to improve)

Please advise,
=dn


----- Original Message -----
From: "Butch Bean" <bbean-list@stripped>
To: "DL Neil" <PHPml@stripped>; "Richard Morton"
<richard.e.morton@stripped>;
<mysql@stripped>
Sent: 25 January 2002 20:03
Subject: RE: Selecting the row with largest number in a column


> The fastest way I found would be:
>
> SELECT MAX(age) FROM contacts
>
> good luck
> bb
>
> -----Original Message-----
> From: DL Neil [mailto:PHPml@stripped]
> Sent: Saturday, January 26, 2002 12:14 PM
> To: Richard Morton; mysql@stripped
> Subject: Re: Selecting the row with largest number in a column
>
>
> Hello Richard,
>
>
> > I have a simple query, and a problem countless people must have had, I
> just
> > cannot work it out at the moment, I am new to MySQL; I hope you can help.
> >
> > My current statement looking at the manual.
> > SELECT * FROM contacts WHERE age=MAX(age);
> >
> > I started with:
> > mysql> select * from contacts where age=(select MAX(age) from contacts);
> >
> >
> > In escence I am trying to ascertain the details of the person who is
> oldest.
> >
> > Any suggestions.?
>
>
> Use the ORDER BY clause to show the table's records in inverted age order,
> then require only the first row:
>
> SELECT *
>   FROM contacts
>   ORDER BY age DESC
>   LIMIT 1
>
> Regards,
> =dn
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread97476@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-bbean-list=gedanken.net@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
>    http://www.mysql.com/manual.php   (the manual)
>    http://lists.mysql.com/           (the list archive)
>
> To request this thread, e-mail <mysql-thread97509@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-PHPml=dande.homechoice.co.uk@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>

Thread
Re: [PHP-DB] any good web hosting with php and mysql support?clint 14 Jan
  • Re: [PHP-DB] any good web hosting with php and mysql support? (OT)Mikel King14 Jan
  • Re: [PHP-DB] any good web hosting with php and mysql support? (OT) Vlasyuk Valera14 Jan
RE: [PHP-DB] any good web hosting with php and mysql support?Rick Emery14 Jan
RE: [PHP-DB] any good web hosting with php and mysql support?NCI/IMS)14 Jan
  • RE: [PHP-DB] any good web hosting with php and mysql support?Shannon Kendrick14 Jan
    • Re: [PHP-DB] any good web hosting with php and mysql support? Vlasyuk Valera14 Jan
      • Selecting the row with largest number in a columnRichard Morton25 Jan
        • Re: Selecting the row with largest number in a columnJoseph Bueno25 Jan
        • Re: Selecting the row with largest number in a columnDL Neil25 Jan
          • Re: Selecting the row with largest number in a columnPaul DuBois25 Jan
          • RE: Selecting the row with largest number in a columnButch Bean25 Jan
            • Re: Selecting the row with largest number in a columnDL Neil26 Jan
            • RE: Selecting the row with largest number in a columnRichard Morton28 Jan
              • RE: Selecting the row with largest number in a columnButch Bean28 Jan
                • RE: Selecting the row with largest number in a columnPaul DuBois28 Jan
                  • RE: Selecting the row with largest number in a columnButch Bean28 Jan
                  • RE: Selecting the row with largest number in a columnButch Bean28 Jan
RE: [PHP-DB] any good web hosting with php and mysql support?Rick Emery14 Jan
RE: [PHP-DB] any good web hosting with php and mysql support?Boaz Yahav17 Jan