Interested to Buy Any Domain ? << Click Here >> for more details...
WHT ARE THE AGGREATE FUNCTIONS?
- 7 Answers
- 10022 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 |
How to find 1st, 2nd, 3rd highest using select select statement not using rownum
What should be the return type for a cursor variable.Can we use a scalar data type as return type?
What are inner join and outer join?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
How to write a left outer join with the where clause in oracle?
What is meant by redo log buffer ?
Why we use bulk collect in oracle?
How to create a new tablespace in oracle?
Write a simple Store procedure and pass parameter to it ?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What is an Integrity Constrains ?
Oracle General 
