what's the best way to look for a value in a number range and update another column based on that information.
eg, i have a table as such;
fromleft toleft fromright toright leftvalue rightvalue lowrange highrange newvalue
100 116 109 115 apple pineapple
204 240 203 241 bananna peach
requirement: need to fill fields lowrange , highrange and newvalue.
i need to show lowrange highrange and what the value gonna be based on that on newvalue field.
as you see , left fields consists of odd range and right field consists of even range of numbers.
i need to do this for a fairly large sample size like 65k. I can use access, excel or oracle.
please suggest me if you have anyidea.
thank you
Last edited: 06-Feb-21 06:37 PM
.png)
