Difference between aggregate function and analytical function?
Answers were Sorted based on User's Feedback
Answer / nb_mopidevi
Aggregate Function : Which returns one row for a group.
Analytical Function : which returns one result for each row in the group.
feedback accepted.
Is This Answer Correct ? | 60 Yes | 2 No |
Answer / 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 |
Answer / pradeep
aggregate function - it returns only single value and (aggr Fun are Min,Max,Count,Sum,Avg)
analytical Function - it returns more than one value and (Analy fun are, string,date, numeric,conversions, and miscellaneous)
Is This Answer Correct ? | 1 Yes | 0 No |
What is delete command in sql?
What are sql constraints?
What is trigger in pl sql?
What is sql mysql pl sql oracle?
Which table is left in left join?
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
How does join work in sql?
Define union, minus, union all, intersect ?
package specification-3 procedures package body-2 procedures will is execute
Can we update views in sql?
What is a sql statement?
What are stored procedures used for?