I want to share it with you today. Use GROUP BY in SQL statements to group statistics. Let's take a look at the data source first.
650) this.width=650; "style=" Float:none; "title=" 11.JPG "src=" http://s3.51cto.com/wyfs02/M01/6E/F7/ Wkiom1wnbcdtuvusaaftxdlyr4i349.jpg "alt=" Wkiom1wnbcdtuvusaaftxdlyr4i349.jpg "/>
Open the data source with Ole DB (refer to the first post in this series for steps)
The last statement, group by item, is grouped by item column.
650) this.width=650; "style=" Float:none; "title=" 12.JPG "src=" http://s3.51cto.com/wyfs02/M02/6E/F4/ Wkiol1wnb32jhtfbaadbe1epx2c070.jpg "alt=" Wkiol1wnb32jhtfbaadbe1epx2c070.jpg "/>
The results are summarized as follows in the item category
650) this.width=650; "title=" 13.JPG "src=" http://s3.51cto.com/wyfs02/M02/6E/F4/wKioL1WNCA3Q4uDcAABpz6qHgrs383.jpg "alt=" Wkiol1wnca3q4udcaabpz6qhgrs383.jpg "/>
This article is from the "Guo Yong Technology blog" blog, make sure to keep this source http://guoyong.blog.51cto.com/408495/1665959
Querying data using SQL statements in Excel (eight)-----GROUP by grouping statistics