Re: Help with minimum/group by

[Vadim Kiryukhin]

if you need just one record:

SELECT a, b, abs(14.3-b) AS c FROM closest ORDER BY c LIMIT 1;

if you need all min records:

SELECT a, b, abs(14.3-b) AS c FROM closest WHERE abs(14.3-b) = (SELECT MIN(abs(14.3-b)) FROM closest);

hope this helps,

-Vadim Kiryukhin