Difference between aggregate function and analytical function?
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 the difference between truncate and drop statements?
What is difference between rank () row_number () and dense_rank () in sql?
How do I run a pl sql procedure in sql developer?
What is union and union all keyword in sql and what are their differences?
What are records give examples?
What is the plv (pl/vision) package offers?
What is a parameter query?
Is clustered index a primary key?
What is sql*loader and what is it used for? : aql loader
How do I truncate a sql log file?
how to use myisamchk to check or repair myisam tables? : Sql dba
What is a unique key and primary key and foreign key?
What is coalesce in sql?
What are the different types of functions in sql?
What is plpgsql language?