Ⅰ sql 如何做季度数据统计
3.按季度分组
select to_char(exportDate,'yyyy-Q'),sum(amount) from table1 group by to_char(exportDate,'yyyy-Q')
order by to_char(exportDate,'yyyy-Q');
试试这个吧
Ⅱ sql server如何按季度分组统计所有的数据
和按月份组的原理是一样的吧！
按月分组
按季度分组和按月分组的区别应该就是时间段的区别吧！
selectcasewhenmonth(date)=1ormonth(date)=2
ormonth(date)=3then'一季度'
whenmonth(date)=4ormonth(date)=5
ormonth(date)=6then'2季度'
whenmonth(date)=7ormonth(date)=8
ormonth(date)=9then'3季度'
whenmonth(date)=10ormonth(date)=11
ormonth(date)=12then'4季度'
else''end,sum(数量)
fromtable
groupby
casewhenmonth(date)=1ormonth(date)=2
ormonth(date)=3then'一季度'
whenmonth(date)=4ormonth(date)=5
ormonth(date)=6then'2季度'
whenmonth(date)=7ormonth(date)=8
ormonth(date)=9then'3季度'
whenmonth(date)=10ormonth(date)=11
ormonth(date)=12then'4季度'
else''end
Ⅲ 已知 ，数据库两个字段，年，月。现在要按照季度分组查询，怎么写sql语句
先case when将月份变成季度，然后再group by即可，SQL如下：
select year, quarter, count(1)
from (
select year,
case
when month < 4 then 1
when month < 7 then 2
when month < 10 then 3
else 4
end as quarter
from table
) as result
group by year, quarter
Ⅳ sql季度汇总
不清楚 年月是按照什么格式写的
所以就说下思路
select ORGCODE,
case when month in(1,2,3) then '第一季度'
when month in(4,5,6) then '第二季度' end ji,
sum(TBJIAF) TBJIAF
where year=条件年份
group by ORGCODE,
case when month in(1,2,3) then '第一季度'
when month in(4,5,6) then '第二季度' end
-----------------------------------------------------
差不多这个格式
Ⅳ sql季度汇总
我没有Oracle环境，这是用sql server做的，可以达到你的要求，这个问题处理的关键在于怎样通过年月来获得季度的汇总，所以要先把ny给分解成年和季度字段（case when 那部分，oracle也支持），剩下的就是简单的group by了。可以参考一下下面的代码。
select 部门编号,年,季度,sum(值)
from
(
SELECT
ORGCODE 部门编号
,SUBSTRING(ny,1,4) 年
,case when 0<SUBSTRING(ny,5,2) AND SUBSTRING(ny,5,2)<4 THEN 1
WHEN 3<SUBSTRING(ny,5,2)AND SUBSTRING(ny,5,2)<7 THEN 2
WHEN 6<SUBSTRING(ny,5,2)AND SUBSTRING(ny,5,2)<10 THEN 3
WHEN 9<SUBSTRING(ny,5,2)AND SUBSTRING(ny,5,2)<13 THEN 4
ELSE 0
END 季度
,JHRWFZ 值
FROM JXKH_YDH
) tmp
group by 部门编号,年,季度
order by 部门编号
Ⅵ sql语句实现分组统计
方法和详细的操作步骤如下：
1、第一步，创建一个测试表，详细代码见下图，转到下面的步骤。
Ⅶ 有1到12月的记录值,怎样用sql分组查出每季度的值
SELECT 字段 from tabel where date1 BETWEEN '2014-01-01 0:00:00' AND '2014-03-31 23:59:59'
SELECT 字段 from tabel where date1 BETWEEN '2014-04-01 0:00:00' AND '2014-06-30 23:59:59'
SELECT 字段 from tabel where date1 BETWEEN '2014-07-01 0:00:00' AND '2014-09-30 23:59:59'
SELECT 字段 from tabel where date1 BETWEEN '2014-10-01 0:00:00' AND '2014-12-31 23:59:59'