Interested to Buy Any Domain ? << Click Here >> for more details...
How to find from a source which has 10,000 records, find the
average between 500th to 600th record?
- 3 Answers
- 9162 Views
- I also Faced
- E-Mail Answers
Answer Posted / sudhar
Your answer is correct for the flat files. But the RElation
query you have given won't give any records.
the Query should like this
select avg(sal) from
(select emp_id, sal, rownum rnum from (
select emp_id,sal from emp order by sal desc) )where rnum
between 500 and 600
Might be this Query can be simplified with Rank option in
Oracle.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How can repository reports be accessed without sql or other transformations?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
Which development components of informatica have the highest usage?
Explain the code page compatibility?
What can we do to improve the performance of informatica aggregator transformation?
What do you mean incremental aggregation?
Differentiate between a repository server and a powerhouse?
update strategy transformation in informatica
When do you use sql override in a lookup transformation?
Quickly characterize reusable change?
What is a mapplet/worklet in informatica?
Explain lookup transformation source types in informatica
complex mapping ur project u r invlve can u explain and give real time example give me ?
How to extract the informatica rejected data?
What is the sequence generator transformation in informatica?
