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 vote203 views1 answer
Get db connection detail from sql developer profile
SQL
0 vote394 views1 answer
Get first match in each group mysql query
SQL
6 votes240 views2 answers
Insert into select mysql
SQL
0 vote194 views1 answer
LoadError: cannot load such file -- mysql2/2.7/mysql2
SQL
0 vote227 views1 answer
Sqlite löschen einer tabelle
SQL
1 vote246 views3 answers
Divide by zero error in sql
SQL
1 vote227 views2 answers
Oracle 18c xe ORA-65096
SQL
1 vote211 views1 answer
Update substring in mysql
SQL
0 vote283 views1 answer
Generate sql from specific migration ef core
SQL
1 vote204 views1 answer
Return size of tables in mysql
SQL