Originally posted by gnagesh
I want a query which should check the range(COL_1) first and then return the least (COL_2) within that range of COL_1.
For Example If I give input for COL_1 as 5 it should return me value of COL_2 5.
TWO values should define a range, shouldn't they?
If the input is 5 what's the second limit?
With two limits the thing looks easy:
Code:
select min(col_2) from the_table
where col_1 between :lower_limit and :upper_limit
Is that you expect?
Ales
The whole difference between a little boy and an adult man is the price of toys