SQL Between: Best Way to Retrieve Desired Range of Values

SQL Between: Best Way to Retrieve Desired Range of Values