对于sqlserver数据库列转行用pivot函数,行转列用unpivot函数。
示例如下:
use test
create table tb2(name varchar(10),project varchar(10),score int)
insert into tb2 values('张三','跳远',300)
insert into tb2 values('张三','跳高',100)
insert into tb2 values('张三','握力',50)
insert into tb2 values('李四','跳远',74)
insert into tb2 values('李四','跳高',84)
insert into tb2 values('李四','握力',94)
select * from tb2
select * from tb2 pivot (max(score) for project in (跳远 ,跳高 ,握力 )) as aa
结果: