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
- 4594 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 are the numeric comparison operations?
How to execute a stored procedure in oracle?
How to get execution statistics reports on query statements?
What is rich query?
How to get execution path reports on query statements?
what happened to the global index when I truncate the data in one of the partition?
What is oracle latest version?
What is the disadvantage of User defind function?
Can we protect our pl/sql source code?
How do we get field details of a table?
Why should I use oracle database?
Explain the use of log option in exp command.
What is a dynamic performance view in oracle?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
please explain.. DB architecture ...
