Re: Finding the closest value

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)),

Finding the closest value

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. I thought about plotting the values in a geometric space, but that would seem to require more dimensions that the server can handle. I thought about