var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: find nearest value
I have a table with values like this:
I want to look up (using a query) let's say, an amount of $850. The rule is: go to the next highest fee if the amount lies between 2 amounts.
For example, $850 would return a fee of $53.
What's a simple way to do this?
Thanks in advance.
off the top of my head...
where amount =
( select min(amount)
where amount > 850 )
I used greater than or equal to, just in case it was right on the lower number.
That was what I needed. Thanks!