ÇóÒ»ÌõsqlÓï¾ä

pid      name    cj      km
--------------------------------------
1 СÁõ 89 ÓïÎÄ
2 СÁõ 98 Êýѧ
3 СÁõ 86 Ó¢Óï
4 ÁõµÂ»ª 95 ÓïÎÄ
5 ÁõµÂ»ª 86 Êýѧ
6 ÁõµÂ»ª 95 Ó¢Óï
7 ÕÅѧÓÑ 95 ÓïÎÄ
8 ÕÅѧÓÑ 66 Êýѧ
9 ÕÅѧÓÑ 89 Ó¢Óï

Óë»ñÈ¡½á¹û:
name    ÓïÎÄ      Êýѧ    Ó¢Óï
--------------------------------------
СÁõ    89        98      86
...

---

select a.name,(select cj from demo where name=a.name and km='ÓïÎÄ' ) as 'ÓïÎÄ',
(select cj from demo where name=a.name and km='Êýѧ' ) as 'Êýѧ',
(select cj from demo where name=a.name and km='Ó¢Óï' ) as 'Ó¢Óï'
  from ( select name from demo group by name ) as a

Õâ¸ö¿ÉÒÔʵÏÖ£¬µ«ÊDz»ÓÃÉϱßÕâÖØkm='ÓïÎÄ'ÕâÖÖÐÎʽʵÏÖ,»¹ÓÐÆäËüµÄ·½·¨°É?

---

Èç¹û¿ÆÄ¿ÊÇÈ·¶¨µÄ£¬Óö¯Ì¬SQL
SQL code:
---²éѯ---
declare @sql varchar(8000)
select
@sql=isnull(@sql+',','')
+'max(case when km='''+km+''' then cj else 0 end) as ['+km+']'
from
(select distinct km from tb) t

set @sql='select name,'+@sql+' from tb group by name'

--print @sql

exec (@sql)

---½á¹û---
name ÓïÎÄ Êýѧ Ó¢Ó