"if you encounter any errors in SAP, send me a screenshot at pramod@learntosap.com, and I will help you resolve the issue."

SQL BETWEEN Operator

SQL TUTORIALS-

SQL BETWEEN Operator

Introduction-

-✅SQL BETWEEN operator is used to filter the result set within a specific range.its also works with numeric, text, and date values.

Emoji Examples in HTML

ID	Name	AGE	SALARY
1	ANNI	25	20000
2	SUJAN	27	25000
3	BOULT	29	30000
4	POOJA	30	35000



SELECT * FROM Employees
WHERE Age BETWEEN 25 AND 27;

✅Result Show :-

Result → ANNI | SUJAN |



SELECT * FROM employee
WHERE salary BETWEEN 20000 AND 32000;

✅Result Show :-

Result → ANNI | SUJAN | BOULT |



SELECT * FROM employee
WHERE emp_id BETWEEN 1 AND 3;

✅Result Show :-

Result → ANNI | SUJAN | BOULT |



SELECT emp_name, salary FROM employee
WHERE salary NOT BETWEEN 20000 AND 30000;

✅Result Show :-

Result → POOJA |

1.Can you use BETWEEN with dates and text values too?

Yes No

2.Can BETWEEN be used with NOT?

Yes No