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

-1 vote219 views1 answer
Utf8_encode mysql
SQL
1 vote223 views1 answer
Error:Got a packet bigger than 'max_allowed_packet' bytes
SQL
1 vote226 views1 answer
Sql group by sum with condition
SQL
7 votes205 views5 answers
Show details of table postgres
SQL
17 votes197 views4 answers
Show tables sql server
SQL
0 vote215 views1 answer
Access mysql database docker container shell
SQL
0 vote203 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote220 views1 answer
Declaring variables in pl sql
SQL
4 votes237 views2 answers
Postgresql float data type
SQL
0 vote170 views1 answer
Mysql select top 2
SQL