Select MIN OR greater than something
987522Feb 18 2013 — edited Feb 19 2013Hi
I need to select a MIN value from column, but if that column contains something bigger than X, then I want to select that something.
Example :
Column
3
9
7
I want to select 3, because ther is nothing that's greater than 10. BUT if column looks like this:
Column
3
9
12
7
15
I want to select 12, because it's the smallest number that is greater than 10.
How can I do such a thing? If I can, that is...