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
- 4505 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 |
What are the differences between char and nchar in oracle?
Explain mutating triggers.
How to use windows user to connect to the server?
Difference between the “verify” and “feedback” command?
how to i write the query 'NISHI' TO N I S H I
4 Answers Attra, Metric Stream,
Can select statements be used on views in oracle?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
What is the max number of columns in an oracle table?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
what are the diffeenes between oracle 9i,oracle 10g
What is system global area (sga) in oracle?
how many triggers we can create on a table
11 Answers G2 Technology, TCS,
Oracle General 
