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 is a nested table and how is it different from a normal table?
Explain enable novalidate constraint.
How to use subqueries with the in operator using oracle?
What are transaction isolation levels supported by oracle?
What do you mean by redo log file mirroring?
Explain the relationship among Database, Tablespace and Data file?
What language does oracle use?
how to get second highest sal of emp table
What is data type in oracle?
Is it possible to enter only time value into a column of a table in sql?
What are the different windows events activated at runtime ?
What is literal?