Let's say I have a result set (records) containing numbers such as:
0
1
2
3
9
16
21
45
100
101
102
103
104
105
106
How might someone write a procedure to get the next lowest number in
this sequence? In this case it would be: 4. Some combination of
Select, Min & When, I am sure, but it escapes me at the moment.