The BETWEEN keyword allows for selecting a values in range. The syntax for the BETWEEN clause is given below
Syntax:
It select all rows whose column has a value between 'value1' and 'value2'.
For example,to select all sales information between January 6, 2005, and January 10, 2005, in Table Store_Information
Syntax
Keywords sql server, microsoft sql server, sql commands, sql tutorial