Question

sql中如何把查出的两行变为两列

result

-------
A
阳性
在一个视图中变为i
列1 列2
A 阳性

这样的

Answer 1

行转列问题，已学生，课程，成绩 表为例
表student(name,course,score)
declare @sql varchar(8000)
begin
set @sql = 'select name as 姓名'
select @sql = @sql + ',SUM(case when course=''' + [course] + ''' then score end) as '+ course + ''
from Student group by name

set @sql = @sql + ',sum(score) as 总分 from student group by name'
end
exec(@sql)

Answer 2

select convert(nvarchar,字段1),convert(nvarchar,字段2)
from(
select 字段1，字段2 from 表 for xml path('')
) a

Answer 3

select sum(decode(colname,'A','A',null)) as 列1
select sum(decode(colname,'阳性','阳性'',null)) as 列2
from tablename