计算每个月的订单量 gourp by
select to_char(订单时间,‘yyyy-mm’),
sum(订单量)
from table
group by to_char(APP_TIME,‘yyyy-mm’)
order by to_char(APP_TIME,‘yyyy-mm’);
计算每个月的订单量 gourp by
select to_char(订单时间,‘yyyy-mm’),
sum(订单量)
from table
group by to_char(APP_TIME,‘yyyy-mm’)
order by to_char(APP_TIME,‘yyyy-mm’);