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

1 vote125 views1 answer
Select count distinct multiple columns sql server
SQL
7 votes131 views2 answers
Mysql get year from date
SQL
0 vote158 views1 answer
Oracle winter time change
SQL
0 vote136 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote122 views1 answer
Create new table pl sql
SQL
16 votes134 views6 answers
This is incompatible with sql_mode=only_full_group_by
SQL
0 vote142 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
8 votes151 views1 answer
Mysql restore database
SQL
4 votes130 views1 answer
Restart for pg_hba.conf file
SQL
15 votes137 views2 answers
Open postgress in terminal mac
SQL