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
- 4414 Views
- Bravura Solutions, Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain joins in oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is the use of oracle?
What happens to the data files if a tablespace is dropped?
Can we create trigger on materialized view in oracle?
Can we connect to ORACLE db using Windows Authentication?
How would you change old and new values in an insert, delete and update triggers?
How to drop an existing table in oracle?
What are the uses of linked server and explain it in detail?
What is the disadvantage of User defind function?
Differentiate between pre-select and pre-query?
What is transport network substrate (tns) in oracle?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
How can we find out the duplicate values in an oracle table?
What is blob datatype?
