/SQL/Between operator

Between operator

Sql between

SELECT column_name(s)
FROM table_name
WHERE column_name BETWEEN value1 AND value2;

8

Between operator

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

0

Similar codes

22 votes101 views3 answers
Join three tables sql
SQL
8 votes106 views1 answer
Oracle add auto_increment column to existing table
SQL
0 vote146 views1 answer
Capabilities of sql select statements
SQL
0 vote105 views2 answers
How to relationship query two different tables in MySQL
SQL
1 vote116 views5 answers
What is in operator in sql
SQL
1 vote113 views1 answer
Error code 1292 mysql workbench
SQL
4 votes121 views2 answers
Could not find driver (SQL: SHOW FULL TABLES WHERE table_type = 'BASE TABLE')
SQL
0 vote62 views1 answer
Get all stored procedures in sql server
SQL
4 votes97 views1 answer
Mysql insert from local csv
SQL
5 votes102 views1 answer
Oracle drop index if exists
SQL

Share