declare @tab table(Class varchar(20),Student varchar(20),Course varchar(50),Grades decimal(7,2));...INSERT INTO TABLE1
VALUES('张三','数学','83')
INSERT INTO TABLE1 VALUES('张三','物理','93')
INSERT
INTO TABLE1...VALUES('李四','语文','74')
INSERT INTO TABLE1
VALUES('李四','数学','84')
INSERT INTO TABLE1 VALUES('李四','物理...','94')
想变成
姓名 语文 数学 物理
张三 73 83 93
李四 74 84 94
declare @sql varchar(4000)
set @sql = 'select Name...+']'
from (select distinct Subject from TABLE1) as a
set @sql =
@sql + ' from TABLE1 group by name'