Do you know about aggregate functions? What is row num function? Can it be used all databases?
- 1 Answers
- 3882 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 Undo Management Advisor in Oracle?
what is RAID technology?which is better RAID 0+1 OR RAID 5?
What do you understand by database schema and what does it hold?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
Can we store images in oracle database?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
When can Hash Cluster used ?
what is reindexing?
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
What is oracle latest version?
Explain an integrity constrains?
Can select statements be used on views in oracle?
Oracle General 
