mysql
select name1,name2,sum(cnt) from test3 group by name1,name2 with rollup
rollup 里返回的是哪个字段集合呢
select name1,name2,sum(cnt) from test3 group by name1,name2 with rollup
rollup 里返回的是哪个字段集合呢
解决方案 »
- 想在两个web之间传递数据,不要用get,php的HttpRequest类有高手用过吗?
- flexpaper 怎么实现 百度文库书签功能
- 收集了50个免费的PHP版短信接口,带试用条数,有兴趣回复本帖,先到先得
- 帮个忙,我朋友一个网站ASPX的能转换成为PHP的吗?
- 大侠何在,采集数据被封ip该怎么办,
- 这段代码什么意思啊 不懂 求解????
- discuz 中读取数据出现了 [color=Red]asdfasdfasdfasdfasdfasdfasdfasdfa[/color] );
- MYSQL数据库数据太多,怎么优化
- ==========NetBeans IDE php 8.0 UTF8编码的问题=======
- 微擎install.php on line 2
- 利用织梦的框架,是不适合做二次开发?
- 求在线excel或者表格编辑保存源码
参看MySQL的手册中的例子(http://dev.mysql.com/doc/refman/5.1/en/group-by-modifiers.html)mysql> SELECT year, country, product, SUM(profit)
-> FROM sales
-> GROUP BY year, country, product WITH ROLLUP;
+------+---------+------------+-------------+
| year | country | product | SUM(profit) |
+------+---------+------------+-------------+
| 2000 | Finland | Computer | 1500 |
| 2000 | Finland | Phone | 100 |
| 2000 | Finland | NULL | 1600 |
| 2000 | India | Calculator | 150 |
| 2000 | India | Computer | 1200 |
| 2000 | India | NULL | 1350 |
| 2000 | USA | Calculator | 75 |
| 2000 | USA | Computer | 1500 |
| 2000 | USA | NULL | 1575 |
| 2000 | NULL | NULL | 4525 |
| 2001 | Finland | Phone | 10 |
| 2001 | Finland | NULL | 10 |
| 2001 | USA | Calculator | 50 |
| 2001 | USA | Computer | 2700 |
| 2001 | USA | TV | 250 |
| 2001 | USA | NULL | 3000 |
| 2001 | NULL | NULL | 3010 |
| NULL | NULL | NULL | 7535 |
+------+---------+------------+-------------+