I need an sql which will retrieve data for last 1 month which is 4 months old. eg if today is 1/8/2016 then need data for whole April.Also condition is if my sql is run on any day of the current month it should still retrieve data from 1st of April for whole month.
SQL to retrive 1 month data which is 4 months old
Collapse
X
Comment