Question

怎么将数据库中横向显示的直,用sql语句使它纵向显示?

select enkey,listkey from indexlists where enkey in('M','A','XS','YS','TZ')
可以得到 一下数据
enkey listkey
a 1
b 2
c 3
怎么修改以上sql语句是结果为
enkey a b c
listkey 1 2 3
求大神解答

Answer 1

select 'enkey' enkey,
cast(sum(case when t.enkey = 'a' then 1 else 0 end) as varchar) a,
cast(sum(case when t.enkey = 'b' then 2 else 0 end) as varchar) b,
cast(sum(case when t.enkey = 'c' then 3 else 0 end) as varchar) c
from (select enkey,listkey from indexlists where enkey in('M','A','XS','YS','TZ') ) t
union all
select 'listkey','a','b','c'

Answer 2

你可以研究一下行列转换语句PIVOT、UNPIVOT