Select * from Subquery
I'd Like to Get Sum of Column1, Sum of Column2 and Total Sum. in Postgres I Can Do It This Way: (Notice the Star) Select *, A+B as Total_Sum from ( Select...
I'd like to get sum of column1, sum of column2 and total sum. In Postgres I can do it this way: (notice the star)
SELECT *, a+b AS total_sum FROM
(
SELECT SUM(column1) AS a, SUM(column2) AS b
FROM table
)
But in Oracle I get an syntax error and have to use this:
SELECT a,b, a+b AS total_sum FROM
(
SELECT SUM(column1) AS a, SUM(column2) AS b
FROM table
)
I have really lot of columns to return so I do not want to write the column names again in the main query. Is there any easy solution?
I cannot use a+b in the inner query because there are not known at this place.
I do not want to use SELECT SELECT SUM(column1) AS a, SUM(column2) AS b, SUM(column1)+SUM(column2) AS total_sum.
1 Answer
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
Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.
