Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between aggregate function and analytical function?
- 3 Answers
- 31411 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
Which command is used to delete a package?
What is t sql in sql server?
What is a call statement? Explain with an example.
What is benefit of creating memory optimized table?
How do you modify a trigger?
What is the mutating table and constraining table?
Can you call pl/sql package functions from within a fast formula?
How can I see all tables in sql?
What is numeric function sql?
How subquery works in sql?
What is the purpose of the sql select top clause?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What are the most important ddl statements in sql?
Do ddl statements need commit?
How do you write a subquery?
