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 votes319 views1 answer
Alter session set nls_date_format
SQL
0 vote289 views1 answer
Postgresql inline table
SQL
9 votes335 views3 answers
Postgres make sql dump
SQL
4 votes305 views1 answer
Add constraint fk
SQL
1 vote305 views1 answer
How to group by month using sql server
SQL
1 vote319 views1 answer
Find a column in all tables postgres
SQL
0 vote293 views1 answer
Mysql date only no time
SQL
1 vote304 views2 answers
Check if word is in column sql
SQL
2 votes307 views1 answer
Oracle drop sequence if exists
SQL
3 votes308 views2 answers
Postgresql remove not null constraint
SQL