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
- 4498 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
How do I escape a reserved word in oracle?
Explain about integrity constraint?
How to start an oracle instance?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is different types of joins?
Whats the benefit of dbms_stats over analyze?
What is a lookup table in oracle?
What are the tools for Oracle ?
Describe an oracle table?
How do you bind variables in oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to add another datafile to a tablespace?
What is a initialization parameter file in oracle?
What is oracle sid?
What is the fastest query method to fetch data from the table?
