EasyBasic SELECT
Show products with stock between 10 and 100
The query
SQL
SELECT name, price, stock
FROM products
WHERE stock BETWEEN 10 AND 100
ORDER BY stock;Note
“BETWEEN is inclusive on both ends, equivalent to >= 10 AND <= 100.
SELECT name, price, stock
FROM products
WHERE stock BETWEEN 10 AND 100
ORDER BY stock;Note
“BETWEEN is inclusive on both ends, equivalent to >= 10 AND <= 100.