I have a variable @k=35.
and a table xrf having contents as show below.
x
+----+
| tt |
+----+
| 20 |
| 30 |
| 40 |
| 50 |
| 60 |
+----+
How to I get the values in between which @k exist in table xrf.
output is 30 and 40.
Advertisement
Answer
Using conditional aggregation
select
max(case when tt <= @k then tt end) lower,
min(case when tt > @k then tt end) upper
from mytable