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 |
Where is the export dump file located?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
Is it possible to enter only time value into a column of a table in sql?
Explain what are the characteristics of data files?
What are the extensions used by oracle reports?
What is forall Statement ?
What is self-referential integrity constraint ?
What is the difference between PFILE and SPFILE in Oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Explain the difference between a procedure and a function? What do you understand by those terms?
Explain what are the different type of segments?
What is the exact use of Collections?