Do you know about aggregate functions? What is row num function? Can it be used all databases?
- 1 Answers
- 3505 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 OCI. What are its uses?
How to rename an existing table?
How to find the duplicate rows count from employees table in oracle?
Please explain joins in oracle?
What is clusters ?
How to define a sub function?
How would you change old and new values in an insert, delete and update triggers?
How many types of tables supported by oracle?
what is the syntax of UPDATE command?
What is the difference between I and G in Oracle?
What is Trace File ?
How to rename an index?
Oracle General 
