How to between in sql

Selects values within the given range.
Example 1: Selects stock with a quantity between 100 and 150.
SELECT * FROM stock
WHERE quantity BETWEEN 100 AND 150;
Example 2: Selects stock with a quantity NOT between 100 and 150.
Alternatively, using the NOT keyword here reverses the logic and selects
values outside the given range.
SELECT * FROM stock
WHERE quantity NOT BETWEEN 100 AND 150;

Similar codes

4 votes343 views1 answer
Oracle nls_date_format
SQL
6 votes354 views2 answers
Subtr Oracle ?
SQL
0 vote315 views1 answer
Php get closest location by latitude longitude
SQL
5 votes333 views3 answers
Show indexes mysql
SQL
2 votes308 views2 answers
Compare date mysql
SQL
0 vote316 views1 answer
Replace string in whole database mysql stackoverflow
SQL
8 votes333 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote329 views2 answers
How to take recent row without limit in mysql
SQL
7 votes303 views1 answer
Forge server hosting
SQL
-1 vote318 views1 answer
Get id from just inserted row mysql server python
SQL