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 the difference between drop and truncate commands?
What is a dynamic query?
What are the three pl sql block types?
How much does sqlite cost?
How to use sql*plus built-in timers?
What is the difference between Union and Union all. Which is faster.
Can procedure in package be overloaded?
What is sql server and ase?
Can there be more than one function with a similar name in a pl/sql block?
How to return multiple rows from the stored procedure?
Can we group by two columns in sql?
what is the command line end user interface - mysql? : Sql dba
explain access control lists. : Sql dba
What are sql functions? Describe in brief different types of sql functions?
How can you select unique records from a table?