Interested to Buy Any Domain ? << Click Here >> for more details...
WHT ARE THE AGGREATE FUNCTIONS?
- 7 Answers
- 10030 Views
- GEITC, TCS, I also Faced
- E-Mail Answers
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 |
Explain the dml?
when a grant option is encountered for a table EMP to a peer sitting beside you who has already having the table of that name (EMP), then what is the result?
difference between bind variable and variable
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Can a View based on another View ?
How translate command is different from replace?
What is the database name in oracle?
What is the use of file param in imp command?
how the indexes are stored in the Oracle Database?
What is MTTR advisor in Oracle?
Differnce between view and index
What is the recommended interval at which to run statspack snapshots, and why?
Oracle General 
