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 the different type of normalization? : Sql dba
Can you load data into multiple tables at once? : aql loader
What is pivot query?
Why having clause is used in sql?
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Can we perform dml in function?
What is graph sql?
Explain autonomous transaction.
How do I truncate a sql log file?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
Does sql profiler affect performance?
What is difference sql and mysql?
What is difference between pls_integer and integer?
What are the basic sql commands?
What is data abstraction in sql?