好像楼主跑错地方了啊,这是oracle区 回答oracle 的方法//按自然周统计 select to_char(date,'iw'),sum() from where group by to_char(date,'iw')//按自然月统计 select to_char(date,'mm'),sum() from where group by to_char(date,'mm')//按季统计 select to_char(date,'q'),sum() from where group by to_char(date,'q')//按年统计 select to_char(date,'yyyy'),sum() from where group by to_char(date,'yyyy')
回答oracle 的方法//按自然周统计
select to_char(date,'iw'),sum()
from
where
group by to_char(date,'iw')//按自然月统计
select to_char(date,'mm'),sum()
from
where
group by to_char(date,'mm')//按季统计
select to_char(date,'q'),sum()
from
where
group by to_char(date,'q')//按年统计
select to_char(date,'yyyy'),sum()
from
where
group by to_char(date,'yyyy')