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 does postgresql compare to "nosql"?
What is set transaction?
how can you create an empty table from an existing table? : Sql dba
what is a composite primary key ? : Sql dba
What are the advantages of sql?
What is a sql trace file?
If a cursor is open, how can we find in a pl/sql block?
Does postgresql run on the cloud?
how would concatenate strings in mysql? : Sql dba
What is a string data type in sql?
What is composite data type in pl sql?
How to load data with sql*loader?
How you can copy a file to file content and file to pl/sql table in advance pl/sql?
Does sql*plus have a pl/sql engine?
Is sql easier than java?