Difference between aggregate function and analytical function?
- 3 Answers
- 30260 Views
- Metric Stream, I also Faced
- E-Mail Answers
Answer Posted / yogish naik
we can observe that the aggregate functions return only one
row per group whereas analytic functions keeps all the rows
in the group. Using the aggregate functions, the select
clause contains only the columns specified in group by
clause and aggregate functions whereas in analytic functions
you can specify all the columns in the table.
The PARTITION BY clause is similar to GROUP By clause, it
specifies the window of rows that the analytic funciton
should operate on.
| Is This Answer Correct ? | 16 Yes | 0 No |
Post New Answer View All Answers
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
Why do we use subquery?
Is sql a backend?
Why is sharding used?
What is nvarchar in sql?
How do I view tables in mysql?
What is row_number () in sql?
What are the packages in pl sql?
what is cross join? : Sql dba
What is the use of double ampersand (&&) in sql queries? Give an example
Is sql a programming?
what is sql in mysql? : Sql dba
How do I remove sql developer from windows 10?
Explain exception handling in pl/sql?
differentiate between float and double. : Sql dba
