How to Use BETWEEN Correctly

The BETWEEN clause is used to validate if a value is in a range. For example

select * from sales where revenue between 1000.00 and 2000.00 ;

select * from sales where sold_at between sysdate - 7 and sysdate ;

IN THIS PAGE