如何创建这样的视图 [英] How can I create a view like this

问题描述

你好专家



想象一下这些记录：

Hello Experts

Imagine these records:

AccountNo    Owner
----------   -------
   543       John 
   543       Bill
   112       George
   112       Sara
   883       James

如何创建此视图：

How can I create this view:

AccountNo        Owner
----------   --------------
   543        John, Bill
   112        George, Sara
   883        James

推荐答案

SELECT 
  AccountNo,
  (SELECT Owner + ','
   FROM MyTable T2
   WHERE T2.AccountNo = T1.AccountNo
   FOR XML PATH('') 
  ) AS Owner
FROM MyTable T1
GROUP BY AccountNo

这篇关于如何创建这样的视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！