WHT ARE THE AGGREATE FUNCTIONS?
Answers were Sorted based on User's Feedback
Answer / gopinath
Aggregate functions are:sum,min,max,count,count distinct
| Is This Answer Correct ? | 15 Yes | 3 No |
Answer / abdul qadir
aggregate function operates on multiple rows and gives single output
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / kiran kumar
Aggregate functions are sum,avg,max,min,standard deviation,variance,count function.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / b.chandan kumar patra
this function returns a single row,based on group of rows.
this function an apperars in select list and having clause
only,
the aggregate functions are
sum(),avg(),min(),max(),count()etc.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / pradeep
Aggregate functions are the group functions which returns
only one output.some of the aggregate functions are sum
(),avg(),min(),max(),coun()..
| Is This Answer Correct ? | 1 Yes | 1 No |
Can a field be used in a report without it appearing in any data group ?
Which is better Oracle or MS SQL? Why?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How can Oracle users be audited?
Where is the export dump file located?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What is a Sequence ?
What is the difference between "as" and "is" in an oracle stored procedure?
What are the attributes of cursor?
Explain about achiever in sql?
How to use attributes of the implicit cursor in oracle?
How to retrieve data from an explicit cursor?