Term: BETWEEN

Definition:
The BETWEEN condition allows retrieving values within a range you specify. It will return the records inclusively, meaning that the end or limit values are also returned. For example, this SQL will return the 'user_id' 1000 through 1050, not 1001 through 1049:

SELECT *

FROM users

WHERE user_id BETWEEN 1000 AND 1050;

• Example SELECT statements using BETWEEN

• Number Functions: Calculate ratio between X and Y columns - This block calculates the ratio betwee...
• Months_Between function - The months_between function returns the number of months between date1 a...
• Convert between Decimal, Binary, Octal and Hex - This one will solve a lot of your problems. :) ...
• Date Functions: MONTHS_BETWEEN - Returns the months in between (separating) two given dates.
• Date/Time Calculations: Get seconds between dates - Calculates the number of seconds between two g...
• BETWEEN Condition - The BETWEEN condition allows you to retrieve values within a range.