oracle 按每天,每周,每月,每季度,每年查询统计数据 //按天统计 select count(dataid) as 每天操作数量, sum() from tablename group by trunc(createtime, 'DD')) //按自然周统计 select to_char(date,'iw'),sum() from tablename group by to_char(date,'iw') //按自然月统计 select to_char(date,'mm'),sum() from tablename group by to_char(date,'mm') //按季统计 select to_char(date,'q'),sum() from tablename group by to_char(date,'q') //按年统计 select to_char(date,'yyyy'),sum() from tablename group by to_char(date,'yyyy')
SQL语句统计每天、每月、每年的 数据
1、每年
select
year(ordertime) 年,
sum(Total) 销售合计
from
订单表
group
by
year(ordertime)
2、每月
select
year(ordertime) 年,
month(ordertime) 月,
sum(Total) 销售合计
from
订单表
group
by
year(ordertime),
month(ordertime
3、每日
select
year(ordertime) 年,
month(ordertime) 月,
day(ordertime) 日,
sum(Total) 销售合计
from
订单表
group
by
year(ordertime),
month(ordertime),
day(ordertime)
另外每日也可以这样:
select
convert(
char
(8),ordertime,112) dt,
sum(Total) 销售合计
from
订单表
group
by
convert(
char
(8),ordertime,112)