Difference between aggregate function and analytical function?
Answer Posted / nb_mopidevi
Aggregate Function : Which returns one row for a group.
Analytical Function : which returns one result for each row in the group.
feedback accepted.
| Is This Answer Correct ? | 60 Yes | 2 No |
Post New Answer View All Answers
How is sql used in oracle?
What is the main reason behind using an index?
difference between anonymous blocks and sub-programs.
What are the syntax and use of the coalesce function?
What is sql scripting?
What is multiple partition?
How do I edit a stored procedure?
What does data normalization mean?
How do I run pl sql in sql developer?
What are the two virtual tables available at the time of database trigger execution?
Can we want to pass a parameter payroll_id to this external pl/sql function, how do we do it?
If a cursor is open, how can we find in a pl/sql block?
Is pl sql different from sql?
Why is a trigger used?
What is column?