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
- 4516 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
what is the scripts in data base?
Can select statements be used on views in oracle?
What is procedure overloading in oracle?
What is tns entry?
What view(s) do you use to associate a users SQLPLUS session with his o/s process?
What are the restrictions on external table columns?
How to check database size in Oracle?
How to use "startup" command to start default instance?
How do we get field detail of a table?
What is the maximum number of triggers that can be applied to a single table?
How do I use unicode codesets with the weblogic jdriver for oracle driver?
Can we save images in a database and if yes, how?
How to create an initialization parameter file?
Give the various rollback segment states.
Differentiate between pre-select and pre-query?
