2019-04-03 SQL Group By某列，预先对该列进行一个预处理，提炼出共有的信息，即关键字case when 列名什么条件 then 赋值 else 赋值 end as 新列名...-白红宇

2019-04-03 SQL Group By某列，预先对该列进行一个预处理，提炼出共有的信息，即关键字case when 列名什么条件 then 赋值 else 赋值 end as 新列名...

阅读量：5301 次

发布时间：2019-06-14

本文共 700 字，大约阅读时间需要 2 分钟。

select sum(发行金额) from( select PoolNameFormat,count(cast(ItemValue as decimal(19,4))) as 发行笔数,sum(cast(ItemValue as decimal(19,4))) as 发行金额 from ( select *, case when PoolName like '%2015%'then 2015  when PoolName like '%2016%'then 2016    when PoolName like '%2017%'then 2017    when PoolName like '%2018%'then 2018    when PoolName like '%2019%'then 2019    else 1990  end as  PoolNameFormat  FROM [InvestSuite].[dbo].[PoolStatistics] as ps  inner join [InvestSuite].[dbo].[AssetPool] as ap  on ps.PoolID=ap.ID  where ps.ItemId=N'400' and cast(ps.ItemValue as decimal(19,4))<1000-- between 1000 and 10000  )a  group by PoolNameFormat   )a

转载于:https://www.cnblogs.com/theDataDigger/p/10650948.html

你可能感兴趣的文章

objective-c overview（二）

查看>>

python查询mangodb

查看>>

consonant combination

查看>>

驱动的本质

查看>>

Swift的高级分享 - Swift中的逻辑控制器

查看>>