Inclusiveness of SQL – BETWEEN operator

Both parameters passed to the BETWEEN operator in SQL are inclusive to it.

e.g. SELECT * FROM Employees WHERE Age BETWEEN 20 and 30;

The above SQL returns all the records from the table – Employees where the age is >= 20 and <= 30. Here the employee records whose age is either 20 or 30 are also retrieved. See the below.

Happy time until my next blog post.. 🙂