Skip to Main Content
Forums

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!

Rounding the aggregate function in a pivot table

839324Feb 13 2011 — edited Feb 13 2011
How do I round the avg(GRADE) when I tried just wrapping it around the avg function I get an error message saying expect aggregate function inside pivot operation

pivot
( avg(GRADE)
for Column
in ('1012222','2221112','333113' );

Thanks for the help.

Edit : Sorry wasn't very clear all thats shown is the pivot part of the statement.

Edited by: 836321 on Feb 13, 2011 8:56 AM

Edited by: 836321 on Feb 13, 2011 8:58 AM
This post has been answered by Peter Gjelstrup on Feb 13 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 13 2011
Added on Feb 13 2011
1 comment
3,715 views