looking for ==> $fname, $lname, $age\n";
push(@list, [$h[0],$h[1],$h[2]]);
}
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 28, 2002 11:28 AM
To: [EMAIL PROTECTED]; Richard Morton; DL Neil;
[EMAIL PROTECTED]
Subject: RE:
8 AM
To: [EMAIL PROTECTED]; Richard Morton; DL Neil;
[EMAIL PROTECTED]
Subject: RE: Selecting the row with largest number in a column
At 10:06 -0500 1/28/02, Butch Bean wrote:
>Richard,
>
>I use this with all kinds of situations.
>I am using this function and others like it on tables with
At 10:06 -0500 1/28/02, Butch Bean wrote:
>Richard,
>
>I use this with all kinds of situations.
>I am using this function and others like it on tables with 100k to 3m
>records.
>They always work best when the field your looking for info on is indexed.
>Order By only causes a second process that se
Richard Morton [mailto:[EMAIL PROTECTED]]
Sent: Sunday, January 27, 2002 6:33 PM
To: [EMAIL PROTECTED]; DL Neil; [EMAIL PROTECTED]
Subject: RE: Selecting the row with largest number in a column
Thanks, but using
SELECT MAX(age) FROM contacts
only gives me the maximum age, not the person with that a
January 2002 20:04
To: DL Neil; Richard Morton; [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Saturday
- Original Message -
From: "Butch Bean" <[EMAIL PROTECTED]>
To: "DL Neil" <[EMAIL PROTECTED]>; "Richard Morton"
<[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
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:[EMAIL PROTECTED]]
Sent: Saturday, January 26, 2002 12:14 PM
To: Richard Morton; [EMAIL PROTECTED]
Subject: Re: Selecting the row with largest number in a column
At 17:13 + 1/26/02, DL Neil wrote:
>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 WHE
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> sel
Richard Morton a écrit :
>
> Hello,
>
> 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 sta
Hello,
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 wher
11 matches
Mail list logo
