表:consume_record
字段:consume?(money類型)
date?(datetime類型)
請(qǐng)問怎么寫四條sql語(yǔ)句分別按日,按周,按月,按季統(tǒng)計(jì)消費(fèi)總量.
如: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])
當(dāng)然癣猾，如果你的oracle報(bào)錯(cuò)：'month'函數(shù)報(bào)錯(cuò)，可以試試 to_char(b.PAYMENT_TIME,'yyyy-mm')
檔
