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
How is a process of pl/sql compiled?
What are pl sql data types?
Is not null in sql?
Is left join inner or outer?
What is sql partition?
How to rename a table?
how to get a list of all tables in a database? : Sql dba
What does where 1/2 mean in sql?
What is foreign key in sql with example?
what are the authentication modes in sql server? : Sql dba
What is lookup table in sql?
What is a constraint? Tell me about its various levels.
What is your daily office routine?
What is information schema in sql?
What are dml commands?