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
- 9207 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
write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa
When do you use sql override in a lookup transformation?
What is a mapplet/worklet in informatica?
How to delete duplicate row using informatica?
How to display session logs based upon particular dates. If I want to display session logs for 1 week from a particular date how can I do it without using unix. ?
Explain dynamic target flat file name generation in informatica
What is parallel processing in informatica?
If informatica has its scheduler why using third party scheduler?
what is size of u r database?
What is workflow? What are the components of the workflow manager?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How do you set a varible in incremental aggregation
How to start a workflow using pmcmd command?
Explain why we use partitioning the session in informatica?
