问题描述

sql行转列，想通过条件来得到自己想要的信息

declare @sql varchar(8000)
select @sql = isnull(@sql + '],[' , '') + course from V_StudentPerformance group by course
set @sql = '[' + @sql + ']'
exec ('select * from (select * from V_StudentPerformance) a pivot (max(performance) for course in (' + @sql + ')) b')

如果我要通过条件来查询想要的资料 要怎么写