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 are the types of Database Links ?
Is insert autocommit in oracle?
What is meant by joins?
After update how do u know how many records got updated
How many types of auditing in Oracle?
What are the uses of linked server and explain it in detail?
Is java required for oracle client?
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
What is enter substitution variable in oracle?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
What are the different types of synonyms?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?