SqlServer »ù´¡ÎÊÌâ

Ô­Êý¾Ý£º



¾­¹ý´ËsqlÓï¾ä²éѯ³öÀ´µÄ½á¹ûÊÇ£º
SQL code:
select Code, Name=stuff((select ','+Name from C t where Code=C.Code for xml path('')), 1, 1, '')
from C





¼ÓÉÏGroup By Code ºóÊÇÕâÑù£º




ÄÇΪʲô²»ÄÜ¼Ó Group By Code £¬Name ÄØ£¿Code£¬Name ÁеÄÊý¾Ý¶¼ÊÇÒ»Ñù°¡£¬ÎªÊ²Ã´²»Äܸù¾ÝÕâÁ½ÁзÖ×éÄØ£¿

---

select * from
(select Code, Name=stuff((select ','+Name from C t where Code=C.Code for xml path('')), 1, 1, '')
from C )t
group by code,name

---

SQL code:

select code ,name from
select Code, Name=stuff((select ','+Name from C t where Code=C.Code for xml path('')), 1, 1, '')
from C
)t
group by code,name

--try

---

µÚ¶þÕÅͼƬµÄnameºÍµÚÒ»ÕŵIJ»Ò»ÑùµÄ

---

select Code, Name=stuff((select ','+Name from C t where Code=C.Code for xml path('')), 1, 1, '')
from C
group by Code,stuff((select ','+Name from C t where Code=C.Code for xml path('')), 1, 1, '')

---

ÎҲŷ´Ó¦¹ýÀ´Ð¡×äÉúÁË

---

ÎÒ¾Í˵Ôõô¿´×ÅÕâô±ðŤ[img=http://forum.csdn.net/PointForum/ui/scripts/csdn/Plugin