有如下表 Sale
syear smonth smoney
2011 1 10
2011 3 20
2011 5 10
2011 1 50
2011 7 10
2011 10 80
2011 1 10
2011 2 10
2011 3 20
2011 1 10
2011 8 100
2011 8 10
2011 12 10
2012 1 10
2012 3 20
2012 5 10
2012 1 50
2012 7 10
2012 10 80
2012 1 10
2012 2 10
2012 3 20
2012 1 10
2012 8 100
2012 8 10
2012 12 10
查出结果为
Syear 第一季度 第二季度 第三季度 第四季度
2011 130 10 120 90
2012 130 10 120 90
用一句SQL如何实现?
若不能,用存储过程也行
SQL?季度?统计?
------解决方案--------------------
----------------------------
-- Author :DBA_Huangzj(發糞塗牆)
-- Date :2013-08-19 17:15:07
-- Version:
-- Microsoft SQL Server 2014 (CTP1) - 11.0.9120.5 (X64)
-- Jun 10 2013 20:09:10
-- Copyright (c) Microsoft Corporation
-- Enterprise Evaluation Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
--
----------------------------
--> 测试数据：[Sale]
if object_id('[Sale]') is not null drop table [Sale]
go
create table [Sale]([syear] int,[smonth] int,[smoney] int)
insert [Sale]
select 2011,1,10 union all
select 2011,3,20 union all
select 2011,5,10 union all
select 2011,1,50 union all
select 2011,7,10 union all
select 2011,10,80 union all
select 2011,1,10 union all
select 2011,2,10 union all
select 2011,3,20 union all
select 2011,1,10 union all
select 2011,8,100 union all
select 2011,8,10 union all
select 2011,12,10 union all
select 2012,1,10 union all
select 2012,3,20 union all
select 2012,5,10 union all
select 2012,1,50 union all
select 2012,7,10 union all