SQL Server 数据库中行变列的SQL语句写法

最新推荐文章于 2023-05-02 22:50:17 发布

hsg77

最新推荐文章于 2023-05-02 22:50:17 发布

阅读量3.6k

点赞数

分类专栏：数据库

本文链接：https://blog.csdn.net/hsg77/article/details/9468249

版权

数据库专栏收录该内容

86 篇文章 0 订阅

订阅专栏

SQL Server 数据库中行变列的SQL语句写法:

求面积的方法:

select LZND,
sum(case when lzfs='出租' then isnull(JFLZMJM,0)+isnull(YFLZMJM,0) else 0 end) as mjm_cz,
sum(case when lzfs='入股' then isnull(JFLZMJM,0)+isnull(YFLZMJM,0) else 0 end) as mjm_rg,
sum(case when lzfs='转包' then isnull(JFLZMJM,0)+isnull(YFLZMJM,0) else 0 end) as mjm_zb,
sum(case when lzfs='转让' then isnull(JFLZMJM,0)+isnull(YFLZMJM,0) else 0 end) as mjm_zr,
sum(case when lzfs='互换' then isnull(JFLZMJM,0)+isnull(YFLZMJM,0) else 0 end) as mjm_hh,
sum(case when lzfs='其他' then isnull(JFLZMJM,0)+isnull(YFLZMJM,0) else 0 end) as mjm_qt
from lz_ht_base
group by LZND

求个数的方法:

select LZND,
sum(case when lzfs='出租' then 1 else 0 end) as gs_cz,
sum(case when lzfs='入股' then 1 else 0 end) as gs_rg,
sum(case when lzfs='转包' then 1 else 0 end) as gs_zb,
sum(case when lzfs='转让' then 1 else 0 end) as gs_zr,
sum(case when lzfs='互换' then 1 else 0 end) as gs_hh,
sum(case when lzfs='其他' then 1 else 0 end) as gs_qt
from lz_ht_base
group by LZND

select LZND,lzfs from lz_ht_base

----the---end----