Solution 1:
You can select every column from that sub-query by aliasing it and adding the alias before the *:
SELECT t.*, a+b AS total_sum
FROM
(
SELECT SUM(column1) AS a, SUM(column2) AS b
FROM table
) t
Select * from subquery
Solution 1:
You can select every column from that sub-query by aliasing it and adding the alias before the *:
SELECT t.*, a+b AS total_sum
FROM
(
SELECT SUM(column1) AS a, SUM(column2) AS b
FROM table
) t