Between keyword sql

Select * From employees
Where salary >= 4000
And salary  <= 6000

We can also use between

Select * From employees
Where salary BETWEEN 4000 AND 6000

Between sql

#The BETWEEN operator selects a range of data between two values. The values can be numbers,
#text, or dates. 
syntax->SELECT column_name(s)
FROM table_name
WHERE column_name
BETWEEN value1 AND value2 
///example///
SELECT * FROM Persons
WHERE LastName
BETWEEN 'Hansen' AND 'Pettersen'

Between keyword in sql

(Between) operator same as  ">= <="
For example: 
Select * From Employees Where salary Between 4000 AND 6000;

Similar codes

2 votes137 views1 answer
Dbms transaction (psql)
SQL
32 votes121 views6 answers
How to change column name in sql
SQL
0 vote108 views1 answer
Concat column value of same user in mysql
SQL
4 votes114 views1 answer
Check database name postgresql
SQL
0 vote118 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
14 votes124 views6 answers
Auto_increment mysql
SQL
0 vote114 views1 answer
Shrink database file in sql server
SQL
9 votes125 views3 answers
Where clause sql
SQL
1 vote111 views1 answer
Does insert into overwrite sql
SQL
0 vote115 views1 answer
Mysql autoincrement valor inicial
SQL