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 |
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
How to run the anonymous block again?
What is schema?
41 Answers Bodhi Global Services, Cognizant, HCL,
What are the differences between a sys and system user and what are the extra privileges available to the sys user?
How to add a new column to an existing table in oracle?
What do you mean by redo log file mirroring?
What happens in oracle commit?
What is truncate oracle?
What is the quickest way to fetch the data from a table?
What is a Database instance ? Explain?
Can cursor variables be stored in PL/SQL tables.If yes how. If not why?
How to end the current transaction in oracle?