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
What are types of exception?
differentiate between float and double. : Sql dba
Can a foreign key be null?
What is difference between hql and native sql?
what is 'trigger' in sql? : Sql dba
What are the ddl commands?
how to see the create table statement of an existing table? : Sql dba
How to write html code in pl sql?
Does a primary key have to be a number?
Where is sql database stored?
Is left join faster than join?
What is the need of merge statement?
Explain unique key in sql.
Does postgresql run on the cloud?
What is plpgsql language?