本月
with a as (SELECT * from m_order where datediff(mm,CreateTime,getdate())=0)
select a.*, id=row_number() over(order by CreateTime asc)from a
上月
with a as (SELECT * from m_order where datediff(mm,CreateTime,getdate())=0)
select a.*, id=row_number() over(order by CreateTime asc)from a