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
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?
What is a clob in sql?
What is percent sign in sql?
What are tables and fields?
What is the basic form of sql query?
Explain the structure of pl/sql in brief.
Can we join more than 2 tables in sql?
what are the advantages a stored procedure? : Sql dba
how to use regular expression in pattern match conditions? : Sql dba
What is not in sql?
what is a trigger in mysql? Define different types of trigger. : Sql dba
What is pl sql commands?
Can we rollback after truncate?
How many sql statements are used?