Peter Brawley wrote:
/>Is there an efficient way to find the closest numerical value, across
>three columns? I do not know if there is a way to find it across one. /
Not sure about efficiency, but if the criterion number is @n, do you
mean ...
SELECT LEAST( ABS(MIN(@n-col1)),
LEAST( ABS(MIN(@n-col2)),
ABS(MIN(@n-col3))
)
)
FROM ...
I think the formula is just right - very clever. But is it possible to
make sure that col1, col2 and col3 are all from the same record?
Thanks in anticipation
Lee
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
