Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between aggregate function and analytical function?
- 3 Answers
- 31381 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 is difference between db2 and sql?
How do I partition a table in sql?
what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba
How is a PL/SQL code compiled?
how to calculate expressions with sql statements? : Sql dba
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Is primary key an index?
how do you know the version of your mysql server? : Sql dba
what does the t-sql command ident_current does? : Transact sql
Do we need to rebuild index after truncate?
name 3 ways to get an accurate count of the number of records in a table? : Sql dba
Explain exception handling in pl/sql?
Can a table have no primary key?
How to avoid using cursors?
What is linq to sql?
