Multiple choice technology databases

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

  1. select col1 from table_a where col1 > 0 and col1 <11

  2. select col1 from table_a where col1 >= 0 and col1 <11

  3. select col1 from table_a where col1 >= 0 and col1 <= 11

  4. select col1 from table_a where col1 > 0 and col1 < =11
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The SQL BETWEEN operator is inclusive of both endpoints. BETWEEN 0 AND 11 includes values 0 and 11, which translates to col1 >= 0 AND col1 <= 11. Options A and B incorrectly exclude one or both endpoints, and D has a syntax error with a space in the <= operator.

Keep practicing — related questions