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 |
What do you mean by a tablespace?
How to convert characters to dates in oracle?
What is Rollback Segment ?
What is define in oracle?
What is set operator oracle?
Explain alias?
What is the difference between an Oracle Schema and an Oracle Instance?
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
Explain the use of grant option in imp command.
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What is the maximum number of CHECK constraints that can be defined on a column ?
What is merge in oracle?