Difference between aggregate function and analytical function?
Answer Posted / 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 |
Post New Answer View All Answers
Why commit is not used in triggers?
what are the differences between char and varchar? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?
Whis is not false in primary key?
Why we use joins in sql?
what is the difference between delete and truncate commands? : Sql dba
Is sql scripting language?
Differentiate between sga and pga.
Is big data nosql?
Can delete statement be rollbacked?
How can we implement rollback or commit statement in a trigger?
Enlist the data types that can be used in pl/sql?
Is sql injection illegal?
How do I save a stored procedure?
What is information schema in sql?