Question

How to use BETWEEN operator in SQL

Answer 1

SELECT *
WHERE Age BETWEEN 50 AND 60
FROM Workers

 

70+ SQL courses for beginners and professionals

Answer 2

SELECT *
WHERE Age NOT BETWEEN 50 AND 60
FROM Workers

 

70+ SQL courses for beginners and professionals

Answer 3

SELECT *
WHERE (Age BETWEEN 50 AND 60) AND (Salary BETWEEN 6000 AND 7000)
FROM Workers

 

70+ SQL courses for beginners and professionals