SQL动态行列变换

最新推荐文章于 2022-09-16 10:52:49 发布

Beentrying

最新推荐文章于 2022-09-16 10:52:49 发布

阅读量225

点赞数 1

分类专栏： SQl

本文链接：https://blog.csdn.net/sxw520xxx/article/details/50836431

版权

SQl 专栏收录该内容

0 篇文章 0 订阅

订阅专栏

DECLARE @sql varchar(8000)
SELECT @sql=isnull(@sql+',','')+'max(case cname when '''+cname+''' then '''+degree+''' else 0 end) ['+cname+']' //动态行列变换
from(
select * from (select * from (select a.stuid,a.classid,a.id,a.degree,a.cid,c.cname from (select b.stuid,a.classid,a.id,b.degree,a.cid from T_couser a left join sc b on a.id=b.cid) a left join course c on a.cid=c.cid)
a, T_stu b where a.stuid=b.sid) a where a.classid='001' or a.sid='001' or a.sname='001'
) AS a
SET @sql='select sid as 学号,sname as 姓名,'+@sql+' from '
exec(@sql)