declare @sql varchar(8000)
set @sql = 'select 姓名,'select @sql = @sql + 'sum(case 科目 when '''+科目+'''
then 分数 else 0 end) as '''+科目+''','
from (select distinct 科目 from mytable) as aselect @sql = left(@sql,len(@sql)-1) + ' from mytable group by 姓名'exec(@sql)
go
set @sql = 'select 姓名,'select @sql = @sql + 'sum(case 科目 when '''+科目+'''
then 分数 else 0 end) as '''+科目+''','
from (select distinct 科目 from mytable) as aselect @sql = left(@sql,len(@sql)-1) + ' from mytable group by 姓名'exec(@sql)
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货