BETWEEN ...AND
Use BETWEEN .. AND operator to display rows based on the range of values.
Values will have an upper limit and lower limit. The lower limit should be specified first.
If the upper limit is specified first, then the SQL query will result in no matching rows.
Example :
