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

3 votes202 views2 answers
Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote214 views1 answer
Postegresql update to null
SQL
0 vote193 views1 answer
Mysql where don't have string
SQL
8 votes208 views1 answer
Oracle search text in all packages
SQL
0 vote192 views1 answer
Downgrading sql localdb visual studio
SQL
1 vote182 views1 answer
Sql delete row with auto increment
SQL
0 vote197 views1 answer
Postgres list tables and row counts
SQL
0 vote194 views1 answer
Postgres drop type
SQL
0 vote185 views2 answers
Drop check constraint in ms sql
SQL
-1 vote169 views1 answer
Mysql if example
SQL