Select * From 表1 where rq between dateadd( 'm',-1,datevalue(year(now())&"-"&month(now())&"-1")) and dateadd('d',-1,datevalue(year(now())&"-"&month(now())&"-1"))