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?
View Complete Post