SQL BETWEEN Operator
SQL BETWEEN Operator – The SQL BETWEEN operator is used to returns records match between two values in WHERE Condition.
The range of value should be text, numbers or dates.
In last sql post we leaned LIKE Operator and SQL IN Operator. In this sql tutorial we will learn SQL BETWEEN Operator with syntax and example.
The SQL BETWEEN Operator Syntax :
SELECT col1, col2 FROM table_name WHERE col1 BETWEEN val1 and val2
Above sql query returns all records whose col1 value from val1 to val2.
The SQL BETWEEN Operator Example:
Here, we have table Student and we want to select records whose id start from 2 to 4.
Here, we need to make sql query which returns student whose id between 2 to 4.
Here, we have table Student with below records.
The SQL Student Table :
ID | Name | City | |
---|---|---|---|
1 | Meera | Bombay | meera@yahoo.com |
2 | Ram | Surat | ram@yahoo.com |
3 | Manoj | Bombay | manoj@yahoo.com |
4 | Vaidehi | Ahmedabad | meera@yahoo.com |
SELECT * FROM Student WHERE ID BETWEEN 2 and 4
The Result of SQL BETWEEN Operator is :
ID | Name | City | |
---|---|---|---|
2 | Ram | Surat | ram@yahoo.com |
3 | Manoj | Bombay | manoj@yahoo.com |
4 | Vaidehi | Ahmedabad | meera@yahoo.com |