Difference between aggregate function and analytical function?
Answer Posted / 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 |
Post New Answer View All Answers
what is a foreign key ? : Sql dba
Which operator is used in query for pattern matching?
What is sql constant?
How to read xml file in oracle pl sql?
What are the advantages of pl sql over sql?
Why is %isopen always false for an implicit cursor?
What is the use of function in sql?
what are the advantages of using stored procedures? : Sql dba
how to enter numeric values as hex numbers? : Sql dba
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
Can you call pl/sql package functions from within a fast formula?
How many types of privileges are available in sql?
what is isam? : Sql dba
What is the purpose of the primary key?
What does count (*) do in sql?