MySQL中WITH ROLLUP修饰符有什么用?
-
王林
转载
-
2023-09-07 20:17:09
859浏览
![MySQL中WITH ROLLUP修饰符有什么用?](//m.sbmmt.com/img/upload/article/000/465/014/169408903329677.jpg)
“WITH ROLLUP”是与 GROUP BY 子句一起使用的修饰符。主要是,它导致摘要输出包含表示更高级别摘要操作的额外行。
mysql> Select Item, SUM(Price) AS Price from ratelist Group by item WITH ROLLUP;
+------+-------+
| Item | Price |
+------+-------+
| A | 502 |
| B | 630 |
| C | 1005 |
| h | 850 |
| T | 250 |
| NULL | 3237 |
+------+-------+
6 rows in set (0.00 sec)
以上就是MySQL中WITH ROLLUP修饰符有什么用?的详细内容,更多请关注php中文网其它相关文章!
声明:本文转载于:tutorialspoint,如有侵犯,请联系admin@php.cn删除