Author: jbear123 | Posted on: 10/23/2010 8:57:31 AM | Views : 270

hi,
How would i make a select statement select the row with the nearest values? e.g.:
I have 3 labels, labels1 2 and 3, with values of 1.2, 2 and 5.8
In my table i have 4 columns, first is the data im after, and the next 3 relate to the three labels.
I want to select one row, where the values of labels match it the closest.
e.g. i have 2 rows:
   label     1       2     3
hello        1     2.5     6
hello2      2     2.6    6.2
for this, the select would select row 1 'hello' because the figures match most closely to the labels.
Can anyone help with this?
Thanks




...

Go to the complete details ...