1• BETWEEN operator is used to display
2rows based on a range of values in a
3row whereas the IN condition operator
4is used to check for values contained
5in a specific set of values.
6• Example of BETWEEN:
7SELECT * FROM Students
8WHERE ROLL_NO BETWEEN 10 AND 50;
9• Example of BETWEEN:
10SELECT * FROM students
11WHERE ROLL_NO IN (8,15,25);
1Select * From employees
2Where salary >= 4000
3And salary <= 6000
4
5We can also use between
6
7Select * From employees
8Where salary BETWEEN 4000 AND 6000