Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Aggregate functions on multiple columns

Wael Abu RezeqMar 13 2015 — edited Mar 14 2015

Hello,

Suppose that I am having a table of 5 columns (where their values are numeric), what if I need to have some aggregation functions (like Max, Min, Avg, StDev) and so on for all of them simultaneously (I mean instead of typing Avg(Col1), Avg(Col2), Avg(Col3),... etc and the same for the rest) . What I am thinking about is something like the below:

ColumnNameAvg ValuesMin ValueMax Value
Price5010200
Cost207130
Profit 255180

Thank you

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 11 2015
Added on Mar 13 2015
13 comments
3,322 views