<a href="http://www.cnblogs.com/newland/archive/2007/09/03/880540.html">http://www.cnblogs.com/newland/archive/2007/09/03/880540.html</a>
--行列互换
use tempdb
go
create table test ( [name] char(10), km char(10) , cj int )
go
--初始化数据
insert into test values('张三','语文',80)
insert into test values('张三','数学',86)
insert into test values('张三','英语',75)
insert into test values('李四','语文',78)
insert into test values('李四','数学',85)
insert into test values('李四','英语',78)
select name,sum(case km when '语文' then cj end) as 语文,
sum(case km when '数学' then cj end) as 数学,
sum(case km when '英语' then cj end) as 英语
from test
group by name
欢迎加群互相学习，共同进步。qq群：ios: 58099570 | android: 330987132 | go：217696290 | python：336880185 | 做人要厚道，转载请注明出处！http://www.cnblogs.com/sunshine-anycall/archive/2009/03/22/1418758.html