🎴 Flashcard Mode
IMS Database Programming and Oracle Architecture
Card1 / 20
Mastered0
Review0
QuestionClick to flip
select col1 from table_a where col1 between 0 and 11 is same as :
AnswerClick to flip back
A
select col1 from table_a where col1 >= 0 and col1 <= 11
💡 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.