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 |
How to insert a new row into a table in oracle?
How to pass parameters to procedures in oracle?
What is currency type in database ?
if you ctreate table identity
How to store only time; not date and time?
How to drop a tablespace?
What is the difference between alert log file and tarce file ?
What are advantages of dateset in datastage?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What is a subquery?
what are pseudocolumns?
What is Data Dictionary Cache in Oracle?