Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between aggregate function and analytical function?
- 3 Answers
- 31374 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
How to raise user-defined exception with custom sqlerrm ?
what is the difference difference between procedure and packages
What is write ahead logging in sql server?
what are different types of keys in sql?
How to return multiple rows from the stored procedure?
Define union, minus, union all, intersect ?
What is a primary key sql?
Explain what is a subquery ?
What is trigger explain with example?
What is trigger in pl sql with examples?
how to select first 5 records from a table? : Sql dba
How to change sql*plus system settings?
define sql insert statement ? : Sql dba
Is sql a oracle?
what are the authentication modes in sql server? How can it be changed? : Sql dba
