Hi, I would be greatful if someone could help me in writing a query.

I have a table as follows:

NAME AGE
Bob 44
Mary 59
James 32

I was wondering if I could select the row that had the nearest age to
the one i specify.

For example I could specify an age of 43. In this case the top row
(Bob's info) would be returned as his age was the nearest to the age of
43 in the query.

Thanks

In article <1159197155.186851.167430 (AT) b28g2000cwb (DOT) googlegroups.com>,
alexp says...
SELECT `NAME`,`AGE`
FROM `table`
WHERE `AGE` = (
SELECT MIN(ABS(`age`-43))
FROM `table`
);
--
PleegWat
Remove caps to reply