+ 1
select amount,date,paid_to from purchases as P with (nolock) where date between convert (date, getdate () -31) and convert (date, getdate () -1) and amount >= 400 this is an example query with a between and condition
1st Jul 2016, 3:12 AM
Stevan Camp