㈠ 我写了一条sql语句查询northwind数据库一年每个季度的销售情况，可是结果每年每季度的结果都是一样的
select Year as 年份
, 第一季度= sum(case Q when 0 then amount end)
, 第二季度= sum(case Q when 1 then amount end)
, 第三季度= sum(case Q when 2 then amount end)
, 第四季度= sum(case Q when 3 then amount end)
from (
select year(ShippedDate) as Y, month(ShippedDate) / 4 as Q,
UnitPrice*Quantity*(1-Discount) as amount
from Orders,[Order Details]
where Orders.OrderID=[Order Details].OrderID
and year(ShippedDate) is not null
group by year(ShippedDate) , month(ShippedDate) / 4
) as a
group by Y
order by Y
㈡ Sql server判断某一日期是在第几季度
DECLARE @month int
set @month=DATEPART(M,CONVERT(varchar(20),GETDATE(),112 ))
select @month as 当前月份,
CASE when @month between 1 and 3 then '第一季度'
when @month between 4 and 6 then '第二季度'
when @month between 7 and 9 then '第三季度'
else '第四季度'
end as 季度
㈢ SQL 如何获取当前季度
SELECTDATEPART(QUARTER,GETDATE())
㈣ 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 如何做季度数据统计
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 返回季度的函数
(month+2)/3
㈦ oracle中查询某一季度数据的sql
一般情况下，你的明细数据表都有个日期字段来表明你明细的时间，
数据量比较小可以这样
select sum(...) from tabname where to_char(时间,'q')=你想查询的季度
如果数据量比较大，建议你根据明细表建立一个快速刷新的物化视图，物化视图是根据季度、星期等等的预先统计数据，到时候你要的数据直接从物化视图中查询即可
㈧ 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 2005 查询本周/本月/本季度/本年的数据
本周数据：select * from Keywords where datediff(week, Addtime,getdate())=0
本月：select * from Keywords where datediff(month, Addtime,getdate())=0
本季度：select * from Keywords where datediff(quarter, Addtime,getdate())=0
本年：select * from Keywords where datediff(year, Addtime,getdate())=0
㈩ sql--按照季度统计销售额 怎么写
俩方法
selectyear(订单.订购日期)年份,
sum(casewhenmonth(订单.订购日期)between1and3then订单明细.单价*订单明细.数量else0end)一季度销售金额,
sum(casewhenmonth(订单.订购日期)between4and6then订单明细.单价*订单明细.数量else0end)二季度销售金额,
sum(casewhenmonth(订单.订购日期)between7and9then订单明细.单价*订单明细.数量else0end)三季度销售金额,
sum(casewhenmonth(订单.订购日期)between10and12then订单明细.单价*订单明细.数量else0end)四季度销售金额
from订单,订单明细
where订单.订单ID=订单明细.订单IDandyear(订单.订购日期)between1996and1998
groupbyyear(订单.订购日期)
selectyear(订单.订购日期)年份,
casewhenmonth(订单.订购日期)between1and3then'一季度'
whenmonth(订单.订购日期)between4and6then'二季度'
whenmonth(订单.订购日期)between7and9then'三季度'
whenmonth(订单.订购日期)between10and12then'四季度'end季度,
sum(订单明细.单价*订单明细.数量)金额
from订单,订单明细
where订单.订单ID=订单明细.订单IDandyear(订单.订购日期)between1996and1998
groupbyyear(订单.订购日期),
casewhenmonth(订单.订购日期)between1and3then'一季度'
whenmonth(订单.订购日期)between4and6then'二季度'
whenmonth(订单.订购日期)between7and9then'三季度'
whenmonth(订单.订购日期)between10and12then'四季度'end
你看你要用哪个