SQL - comando between

Select * From Pagar 

where data between date1 and date2