Show sum at the bottom of column in mysql
mysql
Solution
WITH ROLLUP should perform exactly what you are doing.
Problem
Instead of using the following query to display the sum of a column at the bottom, is there another method than using the Union query ``` select amount from receipt UNION select SUM(amount) from receipt ```