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

0 vote266 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
0 vote345 views1 answer
FIND most frequent word in sql server
SQL
12 votes334 views6 answers
How to install sqlite3 in python
SQL
1 vote293 views2 answers
How to check username in mysql command line
SQL
5 votes309 views1 answer
JBDC
SQL
0 vote325 views1 answer
The package java.sql is not accessible
SQL
0 vote317 views1 answer
Lost connection to mysql
SQL
0 vote402 views1 answer
Compare strings lexicographically in sql
SQL
0 vote330 views2 answers
Connect to mysql server mac terminal
SQL
0 vote315 views1 answer
Mysql select smaller of two values
SQL