Interested to Buy Any Domain ? << Click Here >> for more details...
Do you know about aggregate functions? What is row num function? Can it be used all databases?
- 1 Answers
- 4420 Views
- Bravura Solutions, Cap Gemini, I also Faced
- E-Mail Answers
Answer / nilam
SQL aggregate functions return a single value, calculated from values in a column.
Useful aggregate functions:
AVG() - Returns the average value
COUNT() - Returns the number of rows
FIRST() - Returns the first value
LAST() - Returns the last value
MAX() - Returns the largest value
MIN() - Returns the smallest value
SUM() - Returns the sum
| Is This Answer Correct ? | 6 Yes | 0 No |
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
How to get maxsal , minsal, ename department wise in single query
Explain the statement?? ALTER TABLE TABLE_NAME MOVE; What it the use of above statement??
Explain the types of exception?
Why we use bulk collect in oracle?
What are the built-in functions used for sending Parameters to forms ?
How to use group functions in the select clause using oracle?
What is the maximum number of triggers that can be applied to a single table?
What is the quickest way to fetch the data from a table?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
Explain the use of indexes option in exp command.
Oracle General 
