mysql查询并计算单价,sql语句查询今年单价总金额

sqlserver :

1.  一天的订单总额 : select sum(total ) from  orders

where  created_at>='2019-05-16 00:00:00'

and    created_at

一天24小时各个小时的金额总数

select   convert(varchar(2),GETDATE(),14) ,sum(total ) from  orders

where  created_at>='2019-05-16 00:00:00'

and    created_at

group by   convert(varchar(2),GETDATE(),14)

2. 一周的订单总额

select   sum(total ) from  orders

where  DATEDIFF(WK,created_at,GETDATE()) =0

7天分别的金额总数

select convert(varchar(10),getdate() ,120),sum(total ) from  orders

where  DATEDIFF(WK,created_at,GETDATE()) =0

group by  convert(varchar(10),getdate() ,120)

3. 一个月的订单总额

select   sum(total ) from  orders

where  DATEDIFF(MM,created_at,GETDATE()) =0

一个月中各天数的金额总数

select convert(varchar(10),getdate() ,120),sum(total ) from  orders

where  DATEDIFF(MM,created_at) =0

group by  convert(varchar(10),getdate() ,120)

4. 一个季度的订单总额

select   sum(total ) from  orders

where  DATEDIFF(Quarter,created_at,GETDATE()) =0

一个季度中不同月份的金额总数

select MONTH(created_at),sum(total ) from  orders

where  DATEDIFF(Quarter,created_at) =0

group by  MONTH(created_at)

5.一年的订单总额

select   sum(total ) from  orders

where  DATEDIFF(YEAR,created_at,GETDATE()) =0

一年中各个月份的金额总数

select MONTH(created_at),sum(total ) from  orders

where  DATEDIFF(YEAR,created_at) =0

group by  MONTH(created_at)