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

2 votes242 views1 answer
Add new column not null sql server
SQL
1 vote238 views2 answers
How to add amount between date in sql
SQL
1 vote231 views1 answer
Is sql fast
SQL
13 votes229 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
5 votes230 views3 answers
String concatenation sql server
SQL
5 votes221 views2 answers
Oracle show procedures
SQL
0 vote234 views2 answers
Postgres another version
SQL
2 votes233 views1 answer
Sql create database
SQL
1 vote251 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote256 views1 answer
How to find total working hour in sql
SQL