Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between aggregate function and analytical function?
- 3 Answers
- 31426 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 anonymous block in sql?
What are different types of keys?
What is the maximum rows in csv?
What is sql and db2?
how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba
Does truncate release storage space?
Why do we use subquery?
What is cursor in pl sql?
what is the difference between cluster and non cluster index? : Sql dba
Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?
What are the two characteristics of a primary key?
Can a table contain multiple foreign key’s?
How do I start sql profiler?
What do you mean by field in sql?
How do you sort in sql?
