• 所有问题

    • sql语句分别按日,按周,按月,按季统计金额

    如题所述

    举报该问题
    推荐答案   2022-06-30
    表:consume_record

    字段:consume (money类型)

    date (datetime类型)

    请问怎么写四条sql语句分别按日,按周,按月,按季统计消费总量.

    如:1月 1200元

    2月 3400元

    3月 2800元

    --按日

    selectsum(consume),day([date])fromconsume_recordwhereyear([date])='2006'groupbyday([date])

    --按周quarter

    selectsum(consume),datename(week,[date])fromconsume_recordwhereyear([date])='2006'groupbydatename(week,[date])

    --按月

    selectsum(consume),month([date])fromconsume_recordwhereyear([date])='2006'groupbymonth([date])

    --按季

    selectsum(consume),datename(quarter,[date])fromconsume_recordwhereyear([date])='2006'groupbydatename(quarter,[date])

    当然，如果你的oracle报错：'month'函数报错，可以试试 to_char(b.PAYMENT_TIME,'yyyy-mm')

    档
    温馨提示：答案为网友推荐，仅供参考
    相似回答
    如何写SQL语句按周统计和按季度统计答：--sqlserver2005语法统计按周,月,季,年。--按日--select sum(price),day([date]) from table_name where year([date]) ='2006' group by day([date])--按周quarterselect sum(price),datename(week,price_time) from ble_name whereyear(price_time) = '2008' group by datename(week,p...
    ...现在要按季度查出每个季度订购的金额,写出sql语句,怎么写?答：sum(case when right(日期,2)>='4' and right(日期,2)<='6' then 金额 else 0 end ) as 第二季度,sum(case when right(日期,2)>='7' and right(日期,2)<='9' then 金额 else 0 end ) as 第三季度,sum(case when right(日期,2)>='10' and right(日期,2)<='12' then ...
    sql 分类按月统计答：declare @sql varchar(2000)declare @mon varchar(2)set @sql = 'select 名称'select @sql = @sql + ',sum(case mon when '''+mon+''' then 出售数量 end) ['+mon+'月]'from (select distinct substring(convert(varchar(7),日期,120),6,2) mon from 表) as a select @sql = ...
    sql按月汇总答：按月份 select sum(money)from A group by Year,month 按季度 select ceil(month/3),sum(money)from A group by Year,ceil(month/3)
    sql server如何按季度分组统计所有的数据答：和按月份组的原理是一样的吧！按月分组 按季度分组和按月分组的区别应该就是时间段的区别吧！select case when month(date) =1 or month(date) =2 or month(date)=3 then '一季度' when month(date) =4 or month(date) =5 or month(date)=6 then '2季度' wh...
    sql 按时间统计答：当然可以;用行转列就行了 --静态写法 select 单位,sum(case when year(时间)=2005 and datepart(q,时间)=1 then 值 else 0 end) as 2005一季,sum(case when year(时间)=2005 and datepart(q,时间)=2 then 值 else 0 end) as 2005一季,...from table group by 单位 竖向显示时;select...
    ...月、季度、年分组显示啊?求高手赐教,贴出正确sql追加高分!答：to_char(dt, 'iw') as week from (select (to_date('2013-4-15', 'yyyy-mm-dd') + rownum - 1) dtfrom dual connect by rownum <= to_date('2013-7-15', 'yyyy-mm-dd') -to_date('2013-4-15', 'yyyy-mm-dd'))group by to_char(dt, 'iw')ORDER BY years,week ...
    ...段的日期按周、月、季度分组显示?求高手贴山sql。。。答：where 条件后加 GROUP BY MONTHOFYEAR (WEEK STARING)
    怎么用sql查询昨天,今天,明天和本周的记录答：2、之后在该界面中，点击左上角“新建查询”选项。3、接着在该界面中，输入昨天，今天，明天和本周的记录的sql语句“select * from test2 where time = DATEADD( day,-1, convert(varchar(10),getdate(),120) ); select * from test2 where time= DATEADD( day,0, convert(varchar(10),get...
    大家正在搜
    sql按月累计sql按月分组sql like语句sql语句模糊查询likesql按月sql按月查询sql语句是什么sql语句大全实例教程sql数据库基本语句