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 vote167 views1 answer
Search In the Database using Text
SQL
1 vote183 views1 answer
Sql dcl
SQL
2 votes180 views1 answer
Sql server current date minus 5 years
SQL
0 vote165 views1 answer
Sql get user account
SQL
0 vote182 views1 answer
Clear query cache sql server
SQL
0 vote185 views1 answer
Sql get number of days between two dates
SQL
-1 vote171 views1 answer
Mysql case when multiple conditions
SQL
0 vote133 views1 answer
Mysql convert column to uppercase
SQL
8 votes186 views10 answers
Sql
SQL
0 vote178 views2 answers
How to use aggregate functions in sql
SQL