sql多列合并为一列多行答:SELECT 1, 'a1', 'b1', 'c1', 'd1' UNION ALL SELECT 2, 'a2', 'b2', 'c2', 'd2' UNION ALL SELECT 3, 'a3', 'b3', 'c3', 'd3'GO 1> SELECT 2> CASE 3> WHEN ROW_NUMBER() OVER(partition by id order by [all]) = 1 THEN cast(id as varchar(2))...
如何将SQL查询结果合并成多列?答:select a.姓名,a.身高,a.体重,a.三围,sum(b.语文) as 语文总分,sum(b.数学) as 数学总分,sum(b.英语) as 英语总分,sum(b.麻将) as 麻将总分,sum(b.斗地主) as 斗地主总分from 基本情况 as a,考试成绩 as b where a.姓名=b.姓名group by a.姓名,a.身高,a.体重,a.三围你三围...