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 |
Explain enable novalidate constraint.
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
How do I learn what codesets are available in oracle?
How to increment dates by 1 in oracle?
What is a data dictionary and how can it be created?
How to do clean up if create database failed?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
What is logical backup in oracle?
What is background process in Oracle?
How to display row numbers with the records?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?