In the last episode (Jan 22), Adam Bishop said:
> If I have a dataset as below:
>
> Name, Age, Word
> ----------------------------
> Bob, 13, bill
> Joe, 13, oxo
> Alex, 14, thing
> Jim, 14, blob
> Phil, 14, whatsit
> Ben, 15, doodah
> Rodney, 15, thingy
>
> I want to select the first block where the age is equal, i.e. return
> in the case of the above set, Bob and Joe, and with the same query if
> Bob and Joe didn't exist, return Alex, Jim, and Phil.
>
> In broken SQL, I want to "SELECT * FROM `table` WHERE 'Age'='Age 1st Row';".
How about:
SELECT * FROM mytable WHERE Age=MIN(age);
The smallest and largest values for a column are alawys available
via MIN() and MAX(). If you had wanted the 2nd smallest, or the top 3,
then you would have needed a subquery.
--
Dan Nelson
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
