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
- 4593 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 |
What is meant by redo log buffer ?
How to start a specific oracle instance?
What do you mean by group by clause?
How to create an oracle database?
How do I spool to a csv formatted file using sqlplus?
How to write a query with a full outer join in oracle?
What is Rollback Segment ?
How to assign values to data fields in record variables?
What is a SNAPSHOT ?
What is an oracle wallet?
Whether Oracle satisfy more codd rules or db2 satisfy more codd rules? How meny of each can satisfy ? Please answer me. Advance thanks
Give the constructs of a package, function or a procedure.
Oracle General 
