这将与sql-server 2008一起使用
SELECt p1.ID, ( SELECT NAME + ' and ' FROM YourTable p2 WHERe p2.ID = p1.ID ORDER BY NAME FOR XML PATH('') ) AS Name, sum(Amount) FROM YourTable p1 GROUP BY ID ;
这将与sql-server 2008一起使用
SELECt p1.ID, ( SELECT NAME + ' and ' FROM YourTable p2 WHERe p2.ID = p1.ID ORDER BY NAME FOR XML PATH('') ) AS Name, sum(Amount) FROM YourTable p1 GROUP BY ID ;名师互学网 版权所有 (c)2021-2022 ICP备案号：晋ICP备2021003244-6号
