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 votes175 views3 answers
Postgres drop all tables
SQL
0 vote177 views1 answer
Postgres truncate with cascade
SQL
0 vote137 views1 answer
Debian 10 install postgresql 2ndquadrant
SQL
0 vote136 views1 answer
What is the essence of SQL?
SQL
0 vote150 views1 answer
Sql get highest date from 3 tabels
SQL
22 votes150 views6 answers
Create sql table
SQL
6 votes159 views2 answers
Postgresql pg_dump
SQL
0 vote135 views1 answer
Postgres call view
SQL
0 vote143 views1 answer
Combine 2 columns search query mysql
SQL
0 vote148 views1 answer
What is between keyword used for
SQL