how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / anjan
select rownum,empno,ename,sal from (select
rownum,empno,ename,sal from emp)
group by rownum,empno,ename,sal
having rownum in (1,3,5)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is workflow monitor?
What are mapplets? How is it different from a Reusable Transformation?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
What is aggregate cache in aggregator transformation?
What is option by which we can run all the sessions in a batch simultaneously?
Where do we use mapping variables in informatica?
What is standalone command task?
What are the new features of informatica 9.x at the developer level?
Which means the first record should come as last record and last record should come as first record and load into the target file?
What is expression transformation?
Explain the difference between a data warehouse and a data mart?
What are the components of Informatica? And what is the purpose of each?
What does command task mean?
How many ways are there to do 'remove duplicate records in informatica'?
What is the benefit of partitioning a session?