Select DateSerial(Year(Date()),Month(Date())+1,1)-1 AS 本月最后一天, Date()-Day(Date())+1 AS 本月第一天, DateSerial(Year(Date()),Month(Date()),1)-1 AS 上月最后一天, DateSerial(Year(Date()),Month(Date())-1,1) AS 上月第一天
FROM dbo_gc_rbs
GROUP BY DateSerial(Year(Date()),Month(Date())+1,1)-1, Date()-Day(Date())+1, DateSerial(Year(Date()),Month(Date()),1)-1, DateSerial(Year(Date()),Month(Date())-1,1);