Forum Stats

  • 3,854,261 Users
  • 2,264,344 Discussions
  • 7,905,624 Comments

Discussions

SUM, AVG, and other aggregate function

User_SS7U9
User_SS7U9 Member Posts: 17 Green Ribbon

The 21c documentation here

https://docs.oracle.com/en/database/oracle/oracle-database/21/sqlrf/Aggregate-Functions.html#GUID-62BE676B-AF18-4E63-BD14-25206FEA0848

says

......In the listing of aggregate functions at the end of this section, the functions that allow the windowing_clause are followed by an asterisk (*).......

But when I see the SUM, AVG, and many other functions, they are not followed by *, whereas they do allow windowing clause.

Moreover CORR allows windowing but not followed by *

Moreover CORR_ dosnt allow window clause but it is followed by *, later on I realized that in case of CORR_* star denotes K or S.

So is there any documentation bug?

Is there any documentation ambiguity in case of CORR_*.?

Comments