Difference between aggregate function and analytical function?
- 3 Answers
- 29893 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
What is not equal in sql?
What are the qualities of 2nf?
What is the use of triggers?
what are rollup and cube in t-sql? : Transact sql
Does a user_objects view have an entry for a trigger?
Why is sql better than hql?
How can we connect an Android App to an Oracle database and use the PL/SQL procedural code?
Why do we use view in sql?
Is clustered index a primary key?
How do you drop a trigger?
Does pl sql work in mysql?
What is %type in sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How do you update sql?
what is the difference between char and varchar data types? : Sql dba
