离线 TA的专栏
- 打卡等级：即来则安
- 打卡总天数：19
- 打卡月天数：0
- 打卡总奖励：230
- 最近打卡：2025-04-09 07:24:43
|
目录
- sqlserver降水量数据按照时间分组，行转为列
sqlserver降水量数据按照时间分组，行转为列
查询降雨量数据如下：
按照时间分组，将行转为列
- select TM,
- sum(case when STCD = '57155' then DRP else 0 end) as '57155',
- sum(case when STCD = 'V4101' then DRP else 0 end) as 'V4101',
- sum(case when STCD = 'V4102' then DRP else 0 end) as 'V4102',
- sum(case when STCD = 'V4103' then DRP else 0 end) as 'V4103',
- sum(case when STCD = 'V4104' then DRP else 0 end) as 'V4104',
- sum(case when STCD = 'V4107' then DRP else 0 end) as 'V4107',
- sum(case when STCD = 'V4108' then DRP else 0 end) as 'V4108',
- sum(case when STCD = 'V4109' then DRP else 0 end) as 'V4109',
- sum(case when STCD = 'V4110' then DRP else 0 end) as 'V4110',
- sum(case when STCD = 'V4116' then DRP else 0 end) as 'V4116',
- sum(case when STCD = 'V4127' then DRP else 0 end) as 'V4127',
- sum(case when STCD = 'V4129' then DRP else 0 end) as 'V4129',
- sum(case when STCD = 'V4131' then DRP else 0 end) as 'V4131',
- sum(case when STCD = 'V4138' then DRP else 0 end) as 'V4138',
- sum(case when STCD = 'V4140' then DRP else 0 end) as 'V4140',
- sum(case when STCD = 'V4223' then DRP else 0 end) as 'V4223',
- sum(case when STCD = 'V4224' then DRP else 0 end) as 'V4224',
- sum(case when STCD = 'V4225' then DRP else 0 end) as 'V4225',
- sum(case when STCD = 'V4226' then DRP else 0 end) as 'V4226',
- sum(case when STCD = 'V4307' then DRP else 0 end) as 'V4307',
- sum(case when STCD = 'V4308' then DRP else 0 end) as 'V4308',
- sum(case when STCD = 'V4333' then DRP else 0 end) as 'V4333',
- sum(case when STCD = 'V4602' then DRP else 0 end) as 'V4602',
- sum(case when STCD = 'V4603' then DRP else 0 end) as 'V4603',
- sum(case when STCD = 'V4605' then DRP else 0 end) as 'V4605',
- sum(case when STCD = 'V4606' then DRP else 0 end) as 'V4606',
- sum(case when STCD = 'V4608' then DRP else 0 end) as 'V4608',
- sum(case when STCD = 'V4609' then DRP else 0 end) as 'V4609',
- sum(case when STCD = 'V4610' then DRP else 0 end) as 'V4610',
- sum(case when STCD = 'V4615' then DRP else 0 end) as 'V4615',
- sum(case when STCD = 'V4619' then DRP else 0 end) as 'V4619',
- sum(case when STCD = 'V4622' then DRP else 0 end) as 'V4622',
- sum(case when STCD = 'V4623' then DRP else 0 end) as 'V4623',
- sum(case when STCD = 'V4625' then DRP else 0 end) as 'V4625',
- sum(case when STCD = 'V4629' then DRP else 0 end) as 'V4629',
- sum(case when STCD = 'V4631' then DRP else 0 end) as 'V4631',
- sum(case when STCD = 'V4635' then DRP else 0 end) as 'V4635',
- sum(case when STCD = 'V4642' then DRP else 0 end) as 'V4642',
- sum(case when STCD = 'V4643' then DRP else 0 end) as 'V4643',
- sum(case when STCD = 'V4644' then DRP else 0 end) as 'V4644',
- sum(case when STCD = 'V4645' then DRP else 0 end) as 'V4645',
- sum(case when STCD = 'V4646' then DRP else 0 end) as 'V4646',
- sum(case when STCD = 'V4647' then DRP else 0 end) as 'V4647',
- sum(case when STCD = 'V4648' then DRP else 0 end) as 'V4648',
- sum(case when STCD = 'V4649' then DRP else 0 end) as 'V4649',
- sum(case when STCD = 'V4650' then DRP else 0 end) as 'V4650',
- sum(case when STCD = 'V4652' then DRP else 0 end) as 'V4652',
- sum(case when STCD = 'V4656' then DRP else 0 end) as 'V4656',
- sum(case when STCD = 'V4657' then DRP else 0 end) as 'V4657',
- sum(case when STCD = 'V4672' then DRP else 0 end) as 'V4672',
- sum(case when STCD = 'V4913' then DRP else 0 end) as 'V4913',
- sum(case when STCD = 'V4914' then DRP else 0 end) as 'V4914',
- sum(case when STCD = 'V4926' then DRP else 0 end) as 'V4926',
- sum(case when STCD = 'V4935' then DRP else 0 end) as 'V4935',
- sum(case when STCD = 'V4961' then DRP else 0 end) as 'V4961',
- sum(case when STCD = 'V4963' then DRP else 0 end) as 'V4963',
- sum(case when STCD = 'V4964' then DRP else 0 end) as 'V4964',
- sum(case when STCD = 'V4965' then DRP else 0 end) as 'V4965',
- sum(case when STCD = '61834180' then DRP else 0 end) as '61834180',
- sum(case when STCD = '62024590' then DRP else 0 end) as '62024590',
- sum(case when STCD = '61813040' then DRP else 0 end) as '61813040',
- sum(case when STCD = '61813100' then DRP else 0 end) as '61813100',
- sum(case when STCD = '61813220' then DRP else 0 end) as '61813220',
- sum(case when STCD = '61813228' then DRP else 0 end) as '61813228',
- sum(case when STCD = '61813245' then DRP else 0 end) as '61813245',
- sum(case when STCD = '61813310' then DRP else 0 end) as '61813310',
- sum(case when STCD = '61833850' then DRP else 0 end) as '61833850',
- sum(case when STCD = '61833900' then DRP else 0 end) as '61833900',
- sum(case when STCD = '61833970' then DRP else 0 end) as '61833970',
- sum(case when STCD = '61834010' then DRP else 0 end) as '61834010',
- sum(case when STCD = '61834020' then DRP else 0 end) as '61834020',
- sum(case when STCD = '61834050' then DRP else 0 end) as '61834050',
- sum(case when STCD = '61834055' then DRP else 0 end) as '61834055',
- sum(case when STCD = '61834060' then DRP else 0 end) as '61834060',
- sum(case when STCD = '61834080' then DRP else 0 end) as '61834080',
- sum(case when STCD = '61834090' then DRP else 0 end) as '61834090',
- sum(case when STCD = '61834100' then DRP else 0 end) as '61834100',
- sum(case when STCD = '61834110' then DRP else 0 end) as '61834110',
- sum(case when STCD = '61834120' then DRP else 0 end) as '61834120',
- sum(case when STCD = '61834150' then DRP else 0 end) as '61834150',
- sum(case when STCD = '61834160' then DRP else 0 end) as '61834160',
- sum(case when STCD = '61834170' then DRP else 0 end) as '61834170',
- sum(case when STCD = '61834200' then DRP else 0 end) as '61834200',
- sum(case when STCD = '61834210' then DRP else 0 end) as '61834210',
- sum(case when STCD = '61834260' then DRP else 0 end) as '61834260',
- sum(case when STCD = '61834270' then DRP else 0 end) as '61834270',
- sum(case when STCD = '61834280' then DRP else 0 end) as '61834280',
- sum(case when STCD = '61834300' then DRP else 0 end) as '61834300',
- sum(case when STCD = '61834320' then DRP else 0 end) as '61834320',
- sum(case when STCD = '61834330' then DRP else 0 end) as '61834330',
- sum(case when STCD = '61834345' then DRP else 0 end) as '61834345',
- sum(case when STCD = '61834350' then DRP else 0 end) as '61834350',
- sum(case when STCD = '61834355' then DRP else 0 end) as '61834355',
- sum(case when STCD = '61834540' then DRP else 0 end) as '61834540',
- sum(case when STCD = '61834590' then DRP else 0 end) as '61834590',
- sum(case when STCD = '61834600' then DRP else 0 end) as '61834600',
- sum(case when STCD = '61834605' then DRP else 0 end) as '61834605',
- sum(case when STCD = '61834610' then DRP else 0 end) as '61834610',
- sum(case when STCD = '61834615' then DRP else 0 end) as '61834615',
- sum(case when STCD = '61834620' then DRP else 0 end) as '61834620',
- sum(case when STCD = '61834630' then DRP else 0 end) as '61834630',
- sum(case when STCD = '61834635' then DRP else 0 end) as '61834635',
- sum(case when STCD = '61834640' then DRP else 0 end) as '61834640',
- sum(case when STCD = '61834645' then DRP else 0 end) as '61834645',
- sum(case when STCD = '61834650' then DRP else 0 end) as '61834650',
- sum(case when STCD = '61834660' then DRP else 0 end) as '61834660',
- sum(case when STCD = '61834670' then DRP else 0 end) as '61834670',
- sum(case when STCD = '62022230' then DRP else 0 end) as '62022230',
- sum(case when STCD = '61834250' then DRP else 0 end) as '61834250',
- sum(case when STCD = '61834360' then DRP else 0 end) as '61834360',
- sum(case when STCD = '61834370' then DRP else 0 end) as '61834370',
- sum(case when STCD = '61834380' then DRP else 0 end) as '61834380'
- from ST_PPTN_R
- where stcd in (SELECT DISTINCT STCD from V_RainStation_ALL)
- and TM >= '2024-07-15 08:00:00' and TM <= '2024-07-30 08:00:00'
- group by TM
- ORDER BY TM asc
输出成果：
到此这篇关于sqlserver降水量数据按照时间分组，行转为列的文章就介绍到这了,更多相关sqlserver行转为列内容请搜索晓枫资讯以前的文章或继续浏览下面的相关文章希望大家以后多多支持晓枫资讯！
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！ |
晓枫资讯-科技资讯社区-免责声明
免责声明：以上内容为本网站转自其它媒体，相关信息仅为传递更多信息之目的，不代表本网观点，亦不代表本网站赞同其观点或证实其内容的真实性。
1、注册用户在本社区发表、转载的任何作品仅代表其个人观点，不代表本社区认同其观点。
2、管理员及版主有权在不事先通知或不经作者准许的情况下删除其在本社区所发表的文章。
3、本社区的文章部分内容可能来源于网络，仅供大家学习与参考，如有侵权，举报反馈：  进行删除处理。
4、本社区一切资源不代表本站立场，并不代表本站赞同其观点和对其真实性负责。
5、以上声明内容的最终解释权归《晓枫资讯-科技资讯社区》所有。
|
发表于 2024-8-9 12:48:37
