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 |
Is insert autocommit in oracle?
What is an Oracle sequence?
Two triggers one is before insert and other is after insert are firing on a table.If 10 times you insert in a table.Then how many times before trigger and how many types after trigger will fire in pl/sql.
Why does for update in oracle 8 cause an ora-01002 error?
how many outer joins are used in a single sql query? is there any limitations for using of outer joins?
2 Answers BOB Technologies, Cap Gemini, IBM,
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
how to retrieve 1st and last row of table without using group functions??
What are the different windows events activated at runtime ?
What is oracle rowcount?
what are archived logs?
How many memory layers are in the oracle shared pool?
how do u setup a replication site?