sql to find inbetween values -

i have table this

        b -----------  1.2     2.3  2.3     3.9  3.9     4.34  4.34    5.786 

what data means 1.2-5.786 length of table , 1.2-2.3 has attributes 2.3-3.9 has attributes , on... 1.2 - 5.786 when consider length of entire table(for example here).

i want run query give me rows between 2 values: example:

a =1.1 amd b = 4.234

i having hard time figure out how write query, of queries write leave out edge cases.

this seems work well:

select * yourtable (b > 1.1 , <= 4.234) 

sql fiddle demo

basically make sure b greater lower bound , less or equal upper bound. depending on desired results, may need change b > b >=.