我有以下数据需要分组buid
,duid
并且aid
INSERT INTO XmlTable (id, cid, aid, buid, duid)
VALUES(624220, 68487905, 33, '77D8B242', 'DF6DC7D0')
,(625475, 68487905, 33, '77D8B242', 'DF6DC7D0')
,(659989, 68487905, 33, '77D8B242', 'DF6DC7D0')
,(660076, 68487905, 33, '77D8B242', 'DF6DC7D0')
,(660089, 68487905, 33, '7C06311E', '7C06311E')
,(660361, 68487905, 33, '7C06311E', '7C06311E')
,(662592, 68487905, 33, '3501549D', 'AD8AB9EC')
,(663011, 68487905, 33, '3501549D', 'AD8AB9EC');
并为每个组生成相应的 xml 列表,其中包含各自的id
, 。cid
<IList>
<drive aid="33" buid="77D8B242" duid="DF6DC7D0">
<files id="624220" cid="68487905"/>
<files id="625475" cid="68487905"/>
<files id="659989" cid="68487905"/>
<files id="660076" cid="68487905"/>
</drive>
<drive aid="33" buid="7C06311E" duid="7C06311E">
<files id="660089" cid="68487905"/>
<files id="660361" cid="68487905"/>
</drive>
<drive aid="33" buid="3501549D" duid="AD8AB9EC">
<files id="662592" cid="68487905"/>
<files id="663011" cid="68487905"/>
</drive>
</IList>
对我来说,这有正确的输出: