Difference between aggregate function and analytical function?
- 3 Answers
- 30556 Views
- Metric Stream, I also Faced
- E-Mail Answers
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 the basic sql commands?
Can you selectively load only those records that you need? : aql loader
Can a table have no primary key?
what are string data types? : Sql dba
Which type of cursor is used to execute the dml statement?
Explain what is dbms?
What are the events on which a database trigger can be based?
Do prepared statements prevent sql injection?
what are integrity rules?
What is Histogram?
How to read/write files from pl/sql?
Explain the components of sql?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba
How can we make an if statement within a select statement?
what is a composite primary key ? : Sql dba
