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

0 vote185 views1 answer
Can we rollback in sql
SQL
2 votes178 views1 answer
Postgresql update sequence next value
SQL
1 vote233 views1 answer
Sql where max date
SQL
2 votes181 views3 answers
How to pass password mysql command line
SQL
8 votes192 views1 answer
Oracle search stored procedures for text
SQL
0 vote183 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
1 vote200 views1 answer
Add multiple row table pl sql
SQL
1 vote200 views1 answer
Sql first day quarter
SQL
1 vote283 views4 answers
Alter schema sql
SQL
14 votes233 views3 answers
Inner join sql oracle
SQL