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 procedure function?
what is myisam? : Sql dba
When can we use the where clause and the having clause?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Is sql similar to python?
What is the difference between the conventional and direct path loads? : aql loader
Explain the methods used to protect source code of pl/sql.
What is snowflake sql?
Suppose a student column has two columns, name and marks. How to get name and marks of the top three students.
How does postgresql compare to mysql?
How do you update f as m and m as f from the below table testtable?
tell me about various levels of constraint. : Sql dba
How do I copy a table in sql?
Differentiate between sga and pga.
Which constraints we can use while creating database in sql?