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!

difference between Aggregate function & Analytical function

user614966Jul 16 2014 — edited Jul 16 2014

Can anyone help on this, I know few but wanted to know more technical diferences other than below:-

1) Analytical function works on each rows of table and return single data whereas Aggregate function works on each rows and returns multiple set of data.

2) Few AF are - Lead, Lag, Rank, dense_rank etc whereas listagg, sum, max

Plz correct me if I am wrong.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2014

Added on Jul 16 2014

6 comments

7,781 views