1:例子,有一张book表
2:执行sql求和
SELECT
sum(age)
FROM
student
GROUP BY
age;
3:加上with ROLLUP 查询结果会加上一行,显示总和
SELECT
sum(age)
FROM
student
GROUP BY
age with ROLLUP;
1:例子,有一张book表
2:执行sql求和
SELECT
sum(age)
FROM
student
GROUP BY
age;
3:加上with ROLLUP 查询结果会加上一行,显示总和
SELECT
sum(age)
FROM
student
GROUP BY
age with ROLLUP;