MySQL BETWEEN Clause

The BETWEEN operator is used in combination with WHERE clause match or select a range of data value between two values.

Syntax:

Consider “emp_info” table:

empID empName sale
1 Mark 1000
2 Max 1500
3 Mark 1800
5 John 1500

Output:

empID empName sale
1 Mark 1000
2 Max 1500
3 Mark 1800
4 Mark 3000
5 John 1500