解决方案 »
- 删除多行时,如何实现多行触发
- 怎么操作字段说明?
- 关于 order by 的简单问题
- 建立群集后,默认端口不是1433.修改正确端口号后,客户端ODBC就一定要取消"动态决定端口"才能连接
- sql语句中操作临时表报错There is already an object named '#temp' in the database.
- sqlserver怎么实现多个数据库之间的实时同步
- 如何将数字9转换成字符串'0009'的格式?
- 求一sql语句,正解即结贴
- 怎么让软件知道SQLServer表里已经插入了新的记录?
- 索引高手请进
- 新手求助SQL
- MSSQL求助一功能,以B列为前缀加3位流水更新A列!
,SUM(CASE WHEN RIGHT(datekey,2)<=1 THEN value END)[1月]
,SUM(CASE WHEN RIGHT(datekey,2)<=2 THEN value END)[2月]
,SUM(CASE WHEN RIGHT(datekey,2)<=3 THEN value END)[3月]
,SUM(CASE WHEN RIGHT(datekey,2)<=4 THEN value END)[4月]
,SUM(CASE WHEN RIGHT(datekey,2)<=5 THEN value END)[5月]
,SUM(CASE WHEN RIGHT(datekey,2)<=6 THEN value END)[6月]
,SUM(CASE WHEN RIGHT(datekey,2)<=7 THEN value END)[7月]
,SUM(CASE WHEN RIGHT(datekey,2)<=8 THEN value END)[8月]
,SUM(CASE WHEN RIGHT(datekey,2)<=9 THEN value END)[9月]
,SUM(CASE WHEN RIGHT(datekey,2)<=10 THEN value END)[10月]
,SUM(CASE WHEN RIGHT(datekey,2)<=11 THEN value END)[11月]
,SUM(CASE WHEN RIGHT(datekey,2)<=12 THEN value END)[12月]
FROM(SELECT id,LEFT(datekey,6)datekey,SUM(value)value FROM TB GROUP BY id,LEFT(datekey,6))T
GROUP BY id,LEFT(datekey,4)类似这样