Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between aggregate function and analytical function?
- 3 Answers
- 31343 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
Is keyword pl sql?
How many sql core licenses do I need?
define sql update statement ? : Sql dba
How do you rank data in sql?
What are the two types of periodical indexes?
Explain sql data types?
How do you write a complex sql query?
What is the use of primary key?
what are the advantages a stored procedure? : Sql dba
What is the least restrictive isolation level? : Transact sql
What is data definition language?
How to check if a column is nullable before setting to nullable?
How do I audit the sql sent to the server?
What is exception? What are the types of exceptions?
how to increment dates by 1 in mysql? : Sql dba
