Ò»µÀsql±ÊÊÔÌâ - MS-SQL Server / »ù´¡Àà

Ò»µÀsql±ÊÊÔÌâ
 ÐüÉÍ·Ö£º0 - ½â¾öʱ¼ä£º2009-11-3 12:01 
ÐÕÃû ¿Î³Ì ³É¼¨
ÕÅÈý ÓïÎÄ 100
ÕÅÈý Êýѧ 60
ÕÅÈý Ó¢Óï 80
ÀîËÄ ÓïÎÄ 90
ÀîËÄ Êýѧ 70
ÀîËÄ Ó¢Óï 80
½«Æä±ä³É
ÐÕÃû ÓïÎÄ Êýѧ Ó¢Óï
ÕâÖÖÐÎʽÊä³ö£¬ÓÃsqlÓï¾äʵÏÖ 

---

תµÄ×ÞÀÏ´óµÄ
http://blog.csdn.net/sql_lover/archive/2010/05/04/5556828.aspx

---

SQL code:
select ÐÕÃû,
max(case when ¿Î³Ì='ÓïÎÄ' then ³É¼¨ else 0 end) as ÓïÎÄ,
max(case when ¿Î³Ì='Êýѧ' then ³É¼¨ else 0 end) as Êýѧ,
max(case when ¿Î³Ì='Ó¢Óï' then ³É¼¨ else 0 end) as Ó¢Óï
from tb
group by ÐÕÃû

---

¶î£¬Ó¦¸ÃÊÇdawuguiµÄ ºÇºÇ~~~~

---

ÓÃmaxÖ»ÄÜÈ¡×î´óÖµÒ»¸ö£¬ÎÒÏëÒªÔÚ°ÑÆäËûµÄֵȫȡ³öÀ´

---

Â¥Ö÷ÊÇsql 2000 »¹ÊÇ 2005 ÄØ£¿ 

Èç¹ûÊÇ2005µÄ»°¿ÉÒÔ×Ô¼ºÊ¹ÓÃpivotºÍunpivotÀ´´¦Àí¡£¡£

---

sql 2000

---

ÒýÓÃ

ÓÃmaxÖ»ÄÜÈ¡×î´óÖµÒ»¸ö£¬ÎÒÏëÒªÔÚ°ÑÆäËûµÄֵȫȡ³öÀ´

±¾À´¾ÍÖ»ÓÐÒ»¸öÖµ