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
- 4397 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 advantages of dateset in datastage?
How to call a stored function in oracle?
Explain oracle left join with an example?
How do you find current date and time in oracle?
Please explain compound trigger in oracle?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
Can we store images in oracle database?
How to execute the package in oracle?
What is an oracle database table?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
Display Odd/ Even number of records?
cursor attributes are %isopen ,%notfound,%found,%rowcount but is any attributes there other than these? please tell me asap ..
Oracle General 
