select col1 from table_a where col1 between 0 and 11 is same as :
select col1 from table_a where col1 > 0 and col1 <11
select col1 from table_a where col1 >= 0 and col1 <11
select col1 from table_a where col1 >= 0 and col1 <= 11
select col1 from table_a where col1 > 0 and col1 < =11