TOP CATEGORIES

×

Is BETWEEN inclusive in SQL?

S

Shurbhi

Yes, the BETWEEN operator is inclusive in SQL, which allows values with the WHERE clause for providing a range of values.

Query Example of the BETWEEN Operator in SQL

SELECT * FROM employees [table name]

WHERE salary BETWEEN 10500 AND 50500;

OR

SELECT * FROM employees [table name]

WHERE salary >= 10500 AND salary <= 50500;

0 votes

Your Answer