BETWEEN operator in SQL

 

Cấu trúc: 

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

Ví dụ: 

SELECT * FROM Products
WHERE Price BETWEEN 10 AND 20;