Question · SQL and MySQL course · Module 3: Filtering (WHERE)
BETWEEN vs comparison operators
Which condition gives the same result as: WHERE cena BETWEEN 20 AND 80 ?
Answer options
- WHERE cena > 20 AND cena < 80
- WHERE cena >= 20 AND cena <= 80
- WHERE cena = 20 OR cena = 80
- WHERE cena IN (20, 80)
You can check the correct answer by solving this task in the CodeWorlds game.