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
- 4527 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 |
How to write numeric literals in oracle?
How to create a new table by selecting rows from another table?
What is the maximum limit on the number of columns in a table?
What the is the diff between local index and global index. give some example.
Whats the benefit of dbms_stats over analyze?
How to retrieve 5th highest sal from emp table?
How to use existing values in update statements using oracle?
Explain the use of record length option in exp command.
How do I spool in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How do you store pictures in a database?
What do you mean by cdb and pdb in oracle 12c?
Oracle General 
