How to add row heading to an aggregate query? 1

[ViAn]

I have this query:

select sum(param_1) "PARA1", sum(param_2) "PARA2" from (...)
union
select max(param_1), max(param_2) from (...)

resulting in:

   PARA1                   PARA2
[value of sum(param_1)] [value of sum(param_2)]
[value of max(param_1)] [value of max(param_2)]

Now I want to add row headings, so I get:

          PARA1                PARA2
Sum:   [value of sum(param_1)] [value of sum(param_2)]
Max:   [value of max(param_1)] [value of max(param_2)]

Can this be done? I have tried to read books and search at the web, but I have obviously been searching at wrong places...

-ViAn-

 

[RobCPA]

You're very close. Change your union query to look like:

select "Sum" as description, sum(param_1) "PARA1", ...
union
Select "Max" as description, max(param_1),...


Rob

 

[ViAn]

It seemed very simple and powerful. But I failed to say that I have a direct query to an Oracle database. This error-message appears:

"sum": invalid identifier

Is there an analogue method in Oracle Sql? It would have helped me a lot!

-ViAn-

 

[RobCPA]

Put the sum in single quotes:

select 'sum' as description, sum(param_1)...

Also, the 'as' can be left in or taken out.





Rob

 

[ViAn]

Why have I spent so much time on this? I did actually find a solution that is highly "un-elegant", making a new table with the words "sum", "avg" etc in separate columns and adding the max() of each of these columns to the "sum" and "avg" parts of the select-query, respectively.

But your way is the right way to do it. A star to you, Rob!

-ViAn-