group by汇总后，字符字段的聚合问题

悬赏园豆：100 [待解决问题]

<table border="0" cellspacing="0" cellpadding="0" width="585"> <colgroup span="1"><col span="1" width="64"></col><col span="1" width="102"></col><col span="1" width="35"></col><col span="5" width="64"></col><col span="1" width="64"></col></colgroup> <tbody> <tr height="17"> <td width="64" height="17">xh</td> <td width="102">custor</td> <td width="35">zxs</td> <td width="64">hh</td> <td width="64">pm</td> <td width="64">qty</td> <td width="64">size</td> <td width="64">cm</td> <td class="xl23" width="64">zl</td> </tr> <tr height="17"> <td height="17">A171</td> <td>ANDY</td> <td align="right">1</td> <td>A00787</td> <td>T恤</td> <td align="right">8</td> <td>80*50*60</td> <td>CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">A171</td> <td>ANDY</td> <td> </td> <td>B00555</td> <td>T恤</td> <td align="right">30</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A171</td> <td>ANDY</td> <td> </td> <td>B00557</td> <td>T恤</td> <td align="right">30</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A171</td> <td>ANDY</td> <td> </td> <td>A00772</td> <td>T恤</td> <td align="right">50</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A171</td> <td>ANDY</td> <td> </td> <td>A00773</td> <td>T恤</td> <td align="right">50</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K043</td> <td>hero</td> <td align="right">1</td> <td>*</td> <td>T恤</td> <td align="right">100</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K043</td> <td>hero</td> <td> </td> <td>/</td> <td>T恤</td> <td align="right">90</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A152*</td> <td class="xl22">爱</td> <td class="xl22" align="right">1</td> <td>891</td> <td>T恤</td> <td align="right">60</td> <td>53*33*28</td> <td>CHINA*</td> <td class="xl23" align="right">1.73 </td> </tr> <tr height="17"> <td height="17">A153</td> <td class="xl22">爱</td> <td class="xl22" align="right">1</td> <td>*</td> <td>T恤</td> <td align="right">20</td> <td>53*33*20</td> <td>CHINA</td> <td class="xl23" align="right">1.24 </td> </tr> <tr height="17"> <td height="17">A153</td> <td class="xl22">爱</td> <td class="xl22"> </td> <td>915</td> <td>T恤</td> <td align="right">20</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K042</td> <td class="xl22">冰冻</td> <td class="xl22" align="right">1</td> <td>312</td> <td>T恤</td> <td align="right">45</td> <td>53*33*65</td> <td>CHINA</td> <td class="xl23" align="right">4.01 </td> </tr> <tr height="17"> <td height="17">K042</td> <td class="xl22">冰冻</td> <td class="xl22"> </td> <td>313</td> <td>T恤</td> <td align="right">80</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K042</td> <td class="xl22">冰冻</td> <td class="xl22"> </td> <td>/</td> <td>T恤</td> <td align="right">50</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K042</td> <td class="xl22">冰冻</td> <td class="xl22"> </td> <td>*</td> <td>T恤</td> <td align="right">9</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A162</td> <td class="xl22">脖子</td> <td class="xl22" align="right">1</td> <td>3336</td> <td>T恤</td> <td align="right">146</td> <td>53*33*62</td> <td>CHINA</td> <td class="xl23" align="right">3.83 </td> </tr> <tr height="17"> <td height="17">A181</td> <td class="xl22">脖子</td> <td class="xl22" align="right">1</td> <td>3628</td> <td>T恤</td> <td align="right">145</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">A181</td> <td class="xl22">脖子</td> <td class="xl22"> </td> <td>3340</td> <td>T恤</td> <td align="right">10</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A182</td> <td class="xl22">脖子</td> <td class="xl22" align="right">1</td> <td>3340</td> <td>T恤</td> <td align="right">140</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">A182</td> <td class="xl22">脖子</td> <td class="xl22"> </td> <td>3328</td> <td>T恤</td> <td align="right">40</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A183</td> <td class="xl22">脖子</td> <td class="xl22" align="right">1</td> <td>3328</td> <td>T恤</td> <td align="right">104</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">A183</td> <td class="xl22">脖子</td> <td class="xl22"> </td> <td>3375</td> <td>T恤</td> <td align="right">60</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A184</td> <td class="xl22">脖子</td> <td class="xl22" align="right">1</td> <td>3375</td> <td>T恤</td> <td align="right">87</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">A184</td> <td class="xl22">脖子</td> <td class="xl22"> </td> <td>3365</td> <td>T恤</td> <td align="right">70</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A185</td> <td class="xl22">脖子</td> <td class="xl22" align="right">1</td> <td>3365</td> <td>T恤</td> <td align="right">73</td> <td>53*33*36</td> <td>CHINA</td> <td class="xl23" align="right">2.22 </td> </tr> <tr height="17"> <td height="17">B085</td> <td class="xl22">脖子</td> <td class="xl22" align="right">1</td> <td>3733</td> <td>T恤</td> <td align="right">147</td> <td>53*33*76</td> <td>HK</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">B085</td> <td class="xl22">脖子</td> <td class="xl22"> </td> <td>3734</td> <td>T恤</td> <td align="right">10</td> <td>0</td> <td>HK</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">B086</td> <td class="xl22">脖子</td> <td class="xl22" align="right">1</td> <td>3734</td> <td>T恤</td> <td align="right">140</td> <td>53*33*76</td> <td>HK</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">B086</td> <td class="xl22">脖子</td> <td class="xl22"> </td> <td>3307</td> <td>T恤</td> <td align="right">20</td> <td>0</td> <td>HK</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">B087</td> <td class="xl22">脖子</td> <td class="xl22" align="right">1</td> <td>3307</td> <td>T恤</td> <td align="right">128</td> <td>53*33*56</td> <td>HK</td> <td class="xl23" align="right">3.46 </td> </tr> <tr height="17"> <td height="17">B084</td> <td class="xl22">不不</td> <td class="xl22" align="right">1</td> <td>07-1093</td> <td>T恤</td> <td align="right">216</td> <td>80*50*60</td> <td>HK</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">B084</td> <td class="xl22">不不</td> <td class="xl22"> </td> <td>07-1093*</td> <td>T恤</td> <td align="right">128</td> <td>0</td> <td>HK</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">B084</td> <td class="xl22">不不</td> <td class="xl22"> </td> <td>07-1093+</td> <td>T恤</td> <td align="right">109</td> <td>0</td> <td>HK</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A176</td> <td class="xl22">淡淡</td> <td class="xl22" align="right">1</td> <td>30266</td> <td>T恤</td> <td align="right">28</td> <td>80*50*60</td> <td>CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">A176</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>30219</td> <td>T恤</td> <td align="right">48</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A176</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>30374</td> <td>T恤</td> <td align="right">108</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A176</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>31400</td> <td>T恤</td> <td align="right">72</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A176</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>30586</td> <td>T恤</td> <td align="right">102</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A177</td> <td class="xl22">淡淡</td> <td class="xl22" align="right">1</td> <td>30563</td> <td>T恤</td> <td align="right">108</td> <td>80*50*60</td> <td>CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">A177</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>30192</td> <td>T恤</td> <td align="right">60</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A177</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>30465</td> <td>T恤</td> <td align="right">28</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A177</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>30857</td> <td>T恤</td> <td align="right">72</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A177</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>31094</td> <td>T恤</td> <td align="right">48</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A178</td> <td class="xl22">淡淡</td> <td class="xl22" align="right">1</td> <td>30560</td> <td>T恤</td> <td align="right">108</td> <td>80*50*60</td> <td>CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">A178</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>30562</td> <td>T恤</td> <td align="right">108</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A178</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>31149</td> <td>T恤</td> <td align="right">72</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A178</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>31198</td> <td>T恤</td> <td align="right">48</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A178</td> <td class="xl22">淡淡</td> <td class="xl22"> </td> <td>30760</td> <td>T恤</td> <td align="right">36</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A173</td> <td class="xl22">发</td> <td class="xl22" align="right">1</td> <td>208</td> <td>T恤</td> <td align="right">18</td> <td>53*33*17</td> <td>CHINA</td> <td class="xl23" align="right">1.05 </td> </tr> <tr height="17"> <td height="17">K036</td> <td class="xl22">发财</td> <td class="xl22" align="right">1</td> <td>97547</td> <td>T恤</td> <td align="right">20</td> <td>65*38*67</td> <td>CHINA</td> <td class="xl23" align="right">5.84 </td> </tr> <tr height="17"> <td height="17">K036</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>96572</td> <td>T恤</td> <td align="right">60</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K037</td> <td class="xl22">发财</td> <td class="xl22" align="right">1</td> <td>96572</td> <td>T恤</td> <td align="right">10</td> <td>65*38*67</td> <td>CHINA</td> <td class="xl23" align="right">5.84 </td> </tr> <tr height="17"> <td height="17">K037</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>97550</td> <td>T恤</td> <td align="right">70</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K038</td> <td class="xl22">发财</td> <td class="xl22" align="right">1</td> <td>9002</td> <td>T恤</td> <td align="right">50</td> <td>65*38*67</td> <td>CHINA</td> <td class="xl23" align="right">5.84 </td> </tr> <tr height="17"> <td height="17">K038</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>9005</td> <td>T恤</td> <td align="right">26</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K038</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>1227</td> <td>T恤</td> <td align="right">26</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K038</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>9872</td> <td>T恤</td> <td align="right">20</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K038</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>9883</td> <td>T恤</td> <td align="right">20</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K038</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>332</td> <td>T恤</td> <td align="right">30</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K038</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>331</td> <td>T恤</td> <td align="right">40</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K041</td> <td class="xl22">发财</td> <td class="xl22" align="right">1</td> <td>/</td> <td>T恤</td> <td align="right">60</td> <td>53*33*62</td> <td>CHINA</td> <td class="xl23" align="right">3.83 </td> </tr> <tr height="17"> <td height="17">K041</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>604</td> <td>T恤</td> <td align="right">20</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K041</td> <td class="xl22">发财</td> <td class="xl22"> </td> <td>602</td> <td>T恤</td> <td align="right">30</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K048</td> <td class="xl22">发财</td> <td class="xl22" align="right">1</td> <td>B001</td> <td>T恤</td> <td align="right">70</td> <td>65*38*67</td> <td>CHINA</td> <td class="xl23" align="right">5.84 </td> </tr> <tr height="17"> <td height="17">K40*</td> <td class="xl22">发财</td> <td class="xl22" align="right">1</td> <td>5628-1</td> <td>T恤</td> <td align="right">100</td> <td>80*50*60</td> <td>CHINA*</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">A163</td> <td class="xl22">方方</td> <td class="xl22" align="right">1</td> <td>02</td> <td>T恤</td> <td align="right">16</td> <td>53*33*68</td> <td>CHINA</td> <td class="xl23" align="right">4.20 </td> </tr> <tr height="17"> <td height="17">A163</td> <td class="xl22">方方</td> <td class="xl22"> </td> <td>0731</td> <td>T恤</td> <td align="right">35</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A163</td> <td class="xl22">方方</td> <td class="xl22"> </td> <td>8028</td> <td>T恤</td> <td align="right">30</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A163</td> <td class="xl22">方方</td> <td class="xl22"> </td> <td>915</td> <td>T恤</td> <td align="right">35</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A163</td> <td class="xl22">方方</td> <td class="xl22"> </td> <td>921</td> <td>T恤</td> <td align="right">24</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A163</td> <td class="xl22">方方</td> <td class="xl22"> </td> <td>908</td> <td>T恤</td> <td align="right">10</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">B090</td> <td class="xl22">方方</td> <td class="xl22" align="right">1</td> <td>509</td> <td>T恤</td> <td align="right">25</td> <td>53*33*21</td> <td>HK</td> <td class="xl23" align="right">1.30 </td> </tr> <tr height="17"> <td height="17">A166</td> <td class="xl22">工人</td> <td class="xl22" align="right">1</td> <td>\</td> <td>T恤</td> <td align="right">190</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">A166</td> <td class="xl22">工人</td> <td class="xl22"> </td> <td>*</td> <td>T恤</td> <td align="right">130</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A167</td> <td class="xl22">工人</td> <td class="xl22" align="right">1</td> <td>*</td> <td>T恤</td> <td align="right">70</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">A167</td> <td class="xl22">工人</td> <td class="xl22"> </td> <td>\</td> <td>T恤</td> <td align="right">10</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A167</td> <td class="xl22">工人</td> <td class="xl22"> </td> <td>-</td> <td>T恤</td> <td align="right">150</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A168</td> <td class="xl22">工人</td> <td class="xl22" align="right">1</td> <td>-</td> <td>T恤</td> <td align="right">49</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">A168</td> <td class="xl22">工人</td> <td class="xl22"> </td> <td>|</td> <td>T恤</td> <td align="right">190</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A169</td> <td class="xl22">工人</td> <td class="xl22" align="right">1</td> <td>|</td> <td>T恤</td> <td align="right">10</td> <td>70*50*50</td> <td>CHINA</td> <td class="xl23" align="right">6.18 </td> </tr> <tr height="17"> <td height="17">A169</td> <td class="xl22">工人</td> <td class="xl22"> </td> <td>+</td> <td>T恤</td> <td align="right">90</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A169</td> <td class="xl22">工人</td> <td class="xl22"> </td> <td>|</td> <td>T恤</td> <td align="right">200</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A170</td> <td class="xl22">工人</td> <td class="xl22" align="right">1</td> <td>/</td> <td>T恤</td> <td align="right">200</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">D045</td> <td class="xl22">好好</td> <td class="xl22" align="right">1</td> <td>/</td> <td>T恤</td> <td align="right">251</td> <td>80*50*60</td> <td>HK</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">D046</td> <td class="xl22">好好</td> <td class="xl22" align="right">1</td> <td>*</td> <td>T恤</td> <td align="right">151</td> <td>80*50*60</td> <td>HK</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">D046</td> <td class="xl22">好好</td> <td class="xl22"> </td> <td>+</td> <td>T恤</td> <td align="right">124</td> <td>0</td> <td>HK</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">D047</td> <td class="xl22">好好</td> <td class="xl22" align="right">1</td> <td>+</td> <td>T恤</td> <td align="right">210</td> <td>65*38*67</td> <td>HK</td> <td class="xl23" align="right">5.84 </td> </tr> <tr height="17"> <td height="17">D048</td> <td class="xl22">好好</td> <td class="xl22" align="right">1</td> <td>*</td> <td>T恤</td> <td align="right">185</td> <td>80*50*60</td> <td>HK</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">D049</td> <td class="xl22">好好</td> <td class="xl22" align="right">1</td> <td>-</td> <td>T恤</td> <td align="right">68</td> <td>65*38*60</td> <td>HK</td> <td class="xl23" align="right">5.23 </td> </tr> <tr height="17"> <td height="17">D049</td> <td class="xl22">好好</td> <td class="xl22"> </td> <td>+</td> <td>T恤</td> <td align="right">65</td> <td>0</td> <td>HK</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">D049</td> <td class="xl22">好好</td> <td class="xl22"> </td> <td>*</td> <td>T恤</td> <td align="right">21</td> <td>0</td> <td>HK</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">B088</td> <td class="xl22">看见</td> <td class="xl22" align="right">1</td> <td>1015</td> <td>T恤</td> <td align="right">300</td> <td>53*33*53</td> <td>HK</td> <td class="xl23" align="right">3.27 </td> </tr> <tr height="17"> <td height="17">K032</td> <td class="xl22">口岸</td> <td class="xl22"> </td> <td>0916</td> <td>T恤</td> <td align="right">31</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K032</td> <td class="xl22">口岸</td> <td class="xl22"> </td> <td>0892</td> <td>T恤</td> <td align="right">33</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K032</td> <td class="xl22">口岸</td> <td class="xl22"> </td> <td>0922</td> <td>T恤</td> <td align="right">43</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K032*</td> <td class="xl22">口岸</td> <td class="xl22" align="right">1</td> <td>0927</td> <td>T恤</td> <td align="right">50</td> <td>65*38*67</td> <td>CHINA*</td> <td class="xl23" align="right">5.84 </td> </tr> <tr height="17"> <td height="17">K034</td> <td class="xl22">口岸</td> <td class="xl22" align="right">1</td> <td>5042</td> <td>T恤</td> <td align="right">75</td> <td>65*38*50</td> <td>CHINA</td> <td class="xl23" align="right">4.36 </td> </tr> <tr height="17"> <td height="17">A175</td> <td class="xl22">来来</td> <td class="xl22" align="right">1</td> <td>535</td> <td>T恤</td> <td align="right">25</td> <td>53*33*19</td> <td>CHINA</td> <td class="xl23" align="right">1.17 </td> </tr> <tr height="17"> <td height="17">A186</td> <td class="xl22">来来</td> <td class="xl22" align="right">1</td> <td>0622</td> <td>T恤</td> <td align="right">50</td> <td>53*33*53</td> <td>CHINA</td> <td class="xl23" align="right">3.27 </td> </tr> <tr height="17"> <td height="17">A186</td> <td class="xl22">来来</td> <td class="xl22"> </td> <td>689</td> <td>T恤</td> <td align="right">20</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A186</td> <td class="xl22">来来</td> <td class="xl22"> </td> <td>8802</td> <td>T恤</td> <td align="right">40</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">B089</td> <td class="xl22">来来</td> <td class="xl22" align="right">1</td> <td>310</td> <td>T恤</td> <td align="right">60</td> <td>53*33*26</td> <td>HK</td> <td class="xl23" align="right">1.61 </td> </tr> <tr height="17"> <td height="17">K033</td> <td class="xl22">来来</td> <td class="xl22" align="right">1</td> <td>881</td> <td>T恤</td> <td align="right">80</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K035</td> <td class="xl22">来来</td> <td class="xl22" align="right">1</td> <td>6857</td> <td>T恤</td> <td align="right">60</td> <td>65*38*67</td> <td>CHINA</td> <td class="xl23" align="right">5.84 </td> </tr> <tr height="17"> <td height="17">K035</td> <td class="xl22">来来</td> <td class="xl22"> </td> <td>6858</td> <td>T恤</td> <td align="right">60</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K035</td> <td class="xl22">来来</td> <td class="xl22"> </td> <td>6852</td> <td>T恤</td> <td align="right">90</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K046</td> <td class="xl22">来来</td> <td class="xl22" align="right">1</td> <td>1287</td> <td>T恤</td> <td align="right">60</td> <td>80*50*60</td> <td>CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">K046</td> <td class="xl22">来来</td> <td class="xl22"> </td> <td>1315</td> <td>T恤</td> <td align="right">45</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K046</td> <td class="xl22">来来</td> <td class="xl22"> </td> <td>2671</td> <td>T恤</td> <td align="right">30</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K046</td> <td class="xl22">来来</td> <td class="xl22"> </td> <td>666</td> <td>T恤</td> <td align="right">10</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K047</td> <td class="xl22">来来</td> <td class="xl22" align="right">1</td> <td>666</td> <td>T恤</td> <td align="right">100</td> <td>65*38*67</td> <td>CHINA</td> <td class="xl23" align="right">5.84 </td> </tr> <tr height="17"> <td height="17">K047</td> <td class="xl22">来来</td> <td class="xl22"> </td> <td>702</td> <td>T恤</td> <td align="right">79</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K009</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>3047</td> <td>T恤</td> <td align="right">24</td> <td>61*35*27</td> <td>CHINA</td> <td class="xl23" align="right">2.04 </td> </tr> <tr height="17"> <td height="17">K010</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>3047</td> <td>T恤</td> <td align="right">24</td> <td>61*35*27</td> <td>CHINA</td> <td class="xl23" align="right">2.04 </td> </tr> <tr height="17"> <td height="17">K011</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>36P10</td> <td>T恤</td> <td align="right">24</td> <td>61*35*27</td> <td>CHINA</td> <td class="xl23" align="right">2.04 </td> </tr> <tr height="17"> <td height="17">K012</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>36P10</td> <td>T恤</td> <td align="right">24</td> <td>61*35*27</td> <td>CHINA</td> <td class="xl23" align="right">2.04 </td> </tr> <tr height="17"> <td height="17">K013</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P32</td> <td>T恤</td> <td align="right">24</td> <td>61*35*27</td> <td>CHINA</td> <td class="xl23" align="right">2.04 </td> </tr> <tr height="17"> <td height="17">K014</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P32</td> <td>T恤</td> <td align="right">24</td> <td>61*35*27</td> <td>CHINA</td> <td class="xl23" align="right">2.04 </td> </tr> <tr height="17"> <td height="17">K015</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P11</td> <td>T恤</td> <td align="right">24</td> <td>61*35*27</td> <td>CHINA</td> <td class="xl23" align="right">2.04 </td> </tr> <tr height="17"> <td height="17">K016</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P11</td> <td>T恤</td> <td align="right">24</td> <td>61*35*27</td> <td>CHINA</td> <td class="xl23" align="right">2.04 </td> </tr> <tr height="17"> <td height="17">K017</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P22</td> <td>T恤</td> <td align="right">24</td> <td>61*35*27</td> <td>CHINA</td> <td class="xl23" align="right">2.04 </td> </tr> <tr height="17"> <td height="17">K018</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P22</td> <td>T恤</td> <td align="right">24</td> <td>61*35*28</td> <td>CHINA</td> <td class="xl23" align="right">2.11 </td> </tr> <tr height="17"> <td height="17">K019</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>37P49</td> <td>T恤</td> <td align="right">24</td> <td>61*35*28</td> <td>CHINA</td> <td class="xl23" align="right">2.11 </td> </tr> <tr height="17"> <td height="17">K020</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>37P49</td> <td>T恤</td> <td align="right">24</td> <td>61*35*28</td> <td>CHINA</td> <td class="xl23" align="right">2.11 </td> </tr> <tr height="17"> <td height="17">K021</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>34P21</td> <td>T恤</td> <td align="right">24</td> <td>61*35*28</td> <td>CHINA</td> <td class="xl23" align="right">2.11 </td> </tr> <tr height="17"> <td height="17">K022</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>34P21</td> <td>T恤</td> <td align="right">24</td> <td>61*35*28</td> <td>CHINA</td> <td class="xl23" align="right">2.11 </td> </tr> <tr height="17"> <td height="17">K023</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P22*</td> <td>T恤</td> <td align="right">24</td> <td>61*35*32</td> <td>CHINA</td> <td class="xl23" align="right">2.41 </td> </tr> <tr height="17"> <td height="17">K024</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P22*</td> <td>T恤</td> <td align="right">24</td> <td>61*35*32</td> <td>CHINA</td> <td class="xl23" align="right">2.41 </td> </tr> <tr height="17"> <td height="17">K025</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P32*</td> <td>T恤</td> <td align="right">24</td> <td>61*35*32</td> <td>CHINA</td> <td class="xl23" align="right">2.41 </td> </tr> <tr height="17"> <td height="17">K026</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>38P32*</td> <td>T恤</td> <td align="right">24</td> <td>61*35*32</td> <td>CHINA</td> <td class="xl23" align="right">2.41 </td> </tr> <tr height="17"> <td height="17">K027</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>35P69</td> <td>T恤</td> <td align="right">24</td> <td>61*35*32</td> <td>CHINA</td> <td class="xl23" align="right">2.41 </td> </tr> <tr height="17"> <td height="17">K028</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>35P69</td> <td>T恤</td> <td align="right">24</td> <td>61*35*32</td> <td>CHINA</td> <td class="xl23" align="right">2.41 </td> </tr> <tr height="17"> <td height="17">K044</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>*</td> <td>T恤</td> <td align="right">48</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K045</td> <td class="xl22">脸仍</td> <td class="xl22" align="right">1</td> <td>/</td> <td>T恤</td> <td align="right">72</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K029</td> <td class="xl22">邻居</td> <td class="xl22" align="right">1</td> <td>38P22</td> <td>T恤</td> <td align="right">24</td> <td>61*35*32</td> <td>CHINA</td> <td class="xl23" align="right">2.41 </td> </tr> <tr height="17"> <td height="17">K030</td> <td class="xl22">邻居</td> <td class="xl22" align="right">1</td> <td>38P22</td> <td>T恤</td> <td align="right">24</td> <td>61*35*32</td> <td>CHINA</td> <td class="xl23" align="right">2.41 </td> </tr> <tr height="17"> <td height="17">K031</td> <td class="xl22">邻居</td> <td class="xl22" align="right">1</td> <td>38P22</td> <td>T恤</td> <td align="right">24</td> <td>61*35*32</td> <td>CHINA</td> <td class="xl23" align="right">2.41 </td> </tr> <tr height="17"> <td height="17">A148</td> <td class="xl22">你</td> <td class="xl22" align="right">1</td> <td>3385</td> <td>T恤</td> <td align="right">121</td> <td>70*50*50</td> <td>CHINA</td> <td class="xl23" align="right">6.18 </td> </tr> <tr height="17"> <td height="17">A148</td> <td class="xl22">你</td> <td class="xl22"> </td> <td>3404</td> <td>T恤</td> <td align="right">120</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">J001</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>721-2</td> <td>T恤</td> <td align="right">35</td> <td>80*50*60</td> <td>B/CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">J001</td> <td class="xl22">潘茄</td> <td class="xl22"> </td> <td>721-10</td> <td>T恤</td> <td align="right">13</td> <td>0</td> <td>B/CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">J002</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>721-10</td> <td>T恤</td> <td align="right">22</td> <td>80*50*60</td> <td>B/CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">J002</td> <td class="xl22">潘茄</td> <td class="xl22"> </td> <td>723-1</td> <td>T恤</td> <td align="right">25</td> <td>0</td> <td>B/CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">J003</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>723-1</td> <td>T恤</td> <td align="right">15</td> <td>80*50*60</td> <td>B/CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">J003</td> <td class="xl22">潘茄</td> <td class="xl22"> </td> <td>721-1</td> <td>T恤</td> <td align="right">30</td> <td>0</td> <td>B/CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">J003</td> <td class="xl22">潘茄</td> <td class="xl22"> </td> <td>778-2</td> <td>T恤</td> <td align="right">2</td> <td>0</td> <td>B/CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">J004</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>778-2</td> <td>T恤</td> <td align="right">28</td> <td>65*38*60</td> <td>B/CHINA</td> <td class="xl23" align="right">5.23 </td> </tr> <tr height="17"> <td height="17">K007</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>4301</td> <td>T恤</td> <td align="right">220</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K008</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>108-15</td> <td>T恤</td> <td align="right">15</td> <td>80*50*60</td> <td>B/CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">K008</td> <td class="xl22">潘茄</td> <td class="xl22"> </td> <td>108-3</td> <td>T恤</td> <td align="right">15</td> <td>0</td> <td>B/CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K008</td> <td class="xl22">潘茄</td> <td class="xl22"> </td> <td>108-19A</td> <td>T恤</td> <td align="right">15</td> <td>0</td> <td>B/CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K008</td> <td class="xl22">潘茄</td> <td class="xl22"> </td> <td>7255-1</td> <td>T恤</td> <td align="right">3</td> <td>0</td> <td>B/CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K009</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>7255-1</td> <td>T恤</td> <td align="right">12</td> <td>65*38*70</td> <td>B/CHINA</td> <td class="xl23" align="right">6.11 </td> </tr> <tr height="17"> <td height="17">K009</td> <td class="xl22">潘茄</td> <td class="xl22"> </td> <td>8258-2</td> <td>T恤</td> <td align="right">20</td> <td>0</td> <td>B/CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">K01*</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>4301</td> <td>T恤</td> <td align="right">220</td> <td>53*33*76</td> <td>CHINA*</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K02*</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>4301</td> <td>T恤</td> <td align="right">220</td> <td>53*33*76</td> <td>CHINA*</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K03*</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>4301</td> <td>T恤</td> <td align="right">220</td> <td>53*33*76</td> <td>CHINA*</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K04*</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>4301</td> <td>T恤</td> <td align="right">220</td> <td>53*33*76</td> <td>CHINA*</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K05*</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>4301</td> <td>T恤</td> <td align="right">220</td> <td>53*33*76</td> <td>CHINA*</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K06*</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>4301</td> <td>T恤</td> <td align="right">220</td> <td>53*33*76</td> <td>CHINA*</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">K800*</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>4301</td> <td>T恤</td> <td align="right">230</td> <td>65*38*67</td> <td>CHINA*</td> <td class="xl23" align="right">5.84 </td> </tr> <tr height="17"> <td height="17">L004</td> <td class="xl22">潘茄</td> <td class="xl22"> </td> <td>/</td> <td>T恤</td> <td align="right">-1</td> <td>0</td> <td> </td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">L004</td> <td class="xl22">潘茄</td> <td class="xl22" align="right">1</td> <td>2303-F6</td> <td>T恤</td> <td align="right">40</td> <td>80*50*50</td> <td>B/CHINA</td> <td class="xl23" align="right">7.06 </td> </tr> <tr height="17"> <td height="17">A187</td> <td class="xl22">晟</td> <td class="xl22" align="right">1</td> <td>007-05-17</td> <td>T恤</td> <td align="right">174</td> <td>80*50*60</td> <td>CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">A187</td> <td class="xl22">晟</td> <td class="xl22"> </td> <td>007-05-17</td> <td>T恤</td> <td align="right">37</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A188</td> <td class="xl22">晟</td> <td class="xl22" align="right">1</td> <td>C7338-A</td> <td>T恤</td> <td align="right">178</td> <td>80*50*60</td> <td>CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">A188</td> <td class="xl22">晟</td> <td class="xl22"> </td> <td>C7334-A</td> <td>T恤</td> <td align="right">156</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A188</td> <td class="xl22">晟</td> <td class="xl22"> </td> <td>C7312-A</td> <td>T恤</td> <td align="right">5</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A189</td> <td class="xl22">晟</td> <td class="xl22" align="right"> </td> <td>2007-05-7</td> <td>T恤</td> <td align="right">50</td> <td>53*33*45</td> <td>CHINA</td> <td class="xl23" align="right">2.78 </td> </tr> <tr height="17"> <td height="17">A149</td> <td class="xl22">他</td> <td class="xl22" align="right"> </td> <td>*</td> <td>T恤</td> <td align="right">33</td> <td>80*50*50</td> <td>CHINA</td> <td class="xl23" align="right">7.06 </td> </tr> <tr height="17"> <td height="17">A149</td> <td class="xl22">他</td> <td class="xl22"> </td> <td>C7304-A</td> <td>T恤</td> <td align="right">143</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A149</td> <td class="xl22">他</td> <td class="xl22"> </td> <td>C7311-A</td> <td>T恤</td> <td align="right">122</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A149</td> <td class="xl22">他</td> <td class="xl22"> </td> <td>C7312-A</td> <td>T恤</td> <td align="right">17</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A158</td> <td class="xl22">为为</td> <td class="xl22" align="right">1</td> <td>D8001</td> <td>T恤</td> <td align="right">201</td> <td>70*50*50</td> <td>CHINA</td> <td class="xl23" align="right">6.18 </td> </tr> <tr height="17"> <td height="17">A158</td> <td class="xl22">为为</td> <td class="xl22"> </td> <td>D8002</td> <td>T恤</td> <td align="right">102</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A158</td> <td class="xl22">为为</td> <td class="xl22"> </td> <td>D8005</td> <td>T恤</td> <td align="right">38</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A159</td> <td class="xl22">为为</td> <td class="xl22" align="right">1</td> <td>D8005</td> <td>T恤</td> <td align="right">102</td> <td>53*33*42</td> <td>CHINA</td> <td class="xl23" align="right">2.59 </td> </tr> <tr height="17"> <td height="17">A147</td> <td class="xl22">我</td> <td class="xl22" align="right">1</td> <td>30194</td> <td>T恤</td> <td align="right">90</td> <td>80*50*60</td> <td>CHINA</td> <td class="xl23" align="right">8.48 </td> </tr> <tr height="17"> <td height="17">A147</td> <td class="xl22">我</td> <td class="xl22"> </td> <td>30288</td> <td>T恤</td> <td align="right">28</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A147</td> <td class="xl22">我</td> <td class="xl22"> </td> <td>30588</td> <td>T恤</td> <td align="right">60</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A154</td> <td class="xl22">一样</td> <td class="xl22" align="right">1</td> <td>980</td> <td>T恤</td> <td align="right">11</td> <td>53*33*18</td> <td>CHINA</td> <td class="xl23" align="right">1.11 </td> </tr> <tr height="17"> <td height="17">A154</td> <td class="xl22">一样</td> <td class="xl22"> </td> <td>986</td> <td>T恤</td> <td align="right">14</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A154</td> <td class="xl22">一样</td> <td class="xl22"> </td> <td>987</td> <td>T恤</td> <td align="right">20</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A165</td> <td class="xl22">有有</td> <td class="xl22" align="right">1</td> <td>133</td> <td>T恤</td> <td align="right">70</td> <td>53*33*53</td> <td>CHINA</td> <td class="xl23" align="right">3.27 </td> </tr> <tr height="17"> <td height="17">A174</td> <td class="xl22">在在</td> <td class="xl22" align="right">1</td> <td>8028</td> <td>T恤</td> <td align="right">30</td> <td>53*33*21</td> <td>CHINA</td> <td class="xl23" align="right">1.30 </td> </tr> <tr height="17"> <td height="17">A156</td> <td class="xl22">真好</td> <td class="xl22" align="right">1</td> <td>007</td> <td>T恤</td> <td align="right">60</td> <td>53*33*76</td> <td>CHINA</td> <td class="xl23" align="right">4.69 </td> </tr> <tr height="17"> <td height="17">A156</td> <td class="xl22">真好</td> <td class="xl22"> </td> <td>8100</td> <td>T恤</td> <td align="right">80</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A157</td> <td class="xl22">真好</td> <td class="xl22" align="right">1</td> <td>701</td> <td>T恤</td> <td align="right">80</td> <td>53*33*60</td> <td>CHINA</td> <td class="xl23" align="right">3.71 </td> </tr> <tr height="17"> <td height="17">A157</td> <td class="xl22">真好</td> <td class="xl22"> </td> <td>9801</td> <td>T恤</td> <td align="right">30</td> <td>0</td> <td>CHINA</td> <td class="xl23" align="right">0.00 </td> </tr> <tr height="17"> <td height="17">A164</td> <td class="xl22">中一中</td> <td class="xl22" align="right">1</td> <td>3704</td> <td>T恤</td> <td align="right">78</td> <td>53*33*52</td> <td>CHINA</td> <td class="xl23" align="right">3.21 </td> </tr> <tr height="17"> <td height="17">A172</td> <td class="xl22">中一中</td> <td class="xl22" align="right">1</td> <td>810</td> <td>T恤</td> <td align="right">50</td> <td>53*33*32</td> <td>CHINA</td> <td class="xl23" align="right">1.98 </td> </tr> </tbody> </table> 能否将上表通过程序变成下表 <table border="0" cellspacing="0" cellpadding="0" width="474"> <colgroup span="1"><col span="1" width="64"></col><col span="1" width="282"></col><col span="2" width="64"></col></colgroup> <tbody> <tr height="17"> <td width="64" height="17">custor</td> <td width="282">xh </td> <td width="64">      jx</td> <td width="64">      zl</td> </tr> <tr height="17"> <td height="17">ANDY</td> <td>A171</td> <td align="right">1</td> <td align="right">8.48</td> </tr> <tr height="17"> <td height="17">hero</td> <td>K043</td> <td align="right">1</td> <td align="right">4.69</td> </tr> <tr height="17"> <td class="xl24" height="17">爱</td> <td>A152,A153</td> <td align="right">2</td> <td align="right">2.97</td> </tr> <tr height="17"> <td class="xl24" height="17">冰冻</td> <td>K042</td> <td align="right">1</td> <td align="right">4.01</td> </tr> <tr height="17"> <td class="xl24" height="17">脖子</td> <td>A162,A181-A185,B085-B087</td> <td align="right">9</td> <td align="right">37.65</td> </tr> <tr height="17"> <td class="xl24" height="17">不不</td> <td>B084</td> <td align="right">1</td> <td align="right">8.48</td> </tr> <tr height="17"> <td class="xl24" height="17">淡淡</td> <td>A176-A178</td> <td align="right">3</td> <td align="right">25.44</td> </tr> <tr height="17"> <td class="xl24" height="17">发</td> <td>A173</td> <td align="right">1</td> <td align="right">1.05</td> </tr> <tr height="17"> <td class="xl24" height="17">发财</td> <td>K036-K038,K041,K048.K40</td> <td align="right">6</td> <td align="right">35.67</td> </tr> <tr height="17"> <td class="xl24" height="17">方方</td> <td>A163,B090</td> <td align="right">2</td> <td align="right">5.5</td> </tr> <tr height="17"> <td class="xl24" height="17">工人</td> <td>A166-A170</td> <td align="right">5</td> <td align="right">24.94</td> </tr> <tr height="17"> <td class="xl24" height="17">好好</td> <td>D045-D049</td> <td align="right">5</td> <td align="right">36.51</td> </tr> <tr height="17"> <td class="xl24" height="17">看见</td> <td>B088</td> <td align="right">1</td> <td align="right">3.27</td> </tr> <tr height="17"> <td class="xl24" height="17">口岸</td> <td>K032,K034</td> <td align="right">2</td> <td align="right">10.2</td> </tr> <tr height="17"> <td class="xl24" height="17">来来</td> <td>A175,A186,B089,K033,K035,K046-K047</td> <td align="right">7</td> <td align="right">30.9</td> </tr> </tbody> </table>

数据库 SQL Server

cuiji | 初学一级 | 园豆：0
提问于：2011-01-28 16:46

< >

所有回答(1)

手写的，没有经过测试...你试试能不能达到你的要求

select custor,sum(zl),count(distinct xh) as jx
,xh=max(stuff(
  (select distinct ','+xh from aaaa b where b.custor=a.custor for XML PATH(''))
,1,1,''))
from aaaa a
group by custor

manji | 园豆：633 (小虾三级) | 2011-01-28 18:00

Salvia,您好！你提供的代码，经测试后，总是出现函数错误，烦麻帮忙测试一下,另外句中的aaaa b和aaaa a 代表什么？

支持(0) 反对(0) cuiji | 园豆：0 (初学一级) | 2011-01-28 23:28

from 后面的当然是表名了哦，b 和 a只是重命名而已

支持(0) 反对(0) manji | 园豆：633 (小虾三级) | 2011-01-30 16:30

select custor,sum(zl) zl,count(distinct xh) as jx ,xh=stuff( (select distinct ','+xh from tab_xh b where b.custor=a.custor for XML PATH('')),1,1,'') from tab_xh a group by custor

支持(0) 反对(0) manji | 园豆：633 (小虾三级) | 2011-01-31 15:48

清除回答草稿

您需要登录以后才能回答，未注册用户请先注册。

欢迎，请先 登录 或者 注册 。

group by汇总后，字符字段的聚合问题

欢迎，请先登录或者注册。