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
How can we remove the duplicates from flat file source?
What is meant by lookup transformation?
Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.
How to implement security measures using repository manager?
what are 3 tech challenges/ common issues you face?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
Explain Dataware house architecture .how data flow from intial to end?
How to use procedural logic inside infromatica?
Explain constraint based loading in informatica
What is the difference between writing a joiner query in ANSI style and THETA style?
What is resilience time?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
draw informatica architecture 8.6 ?
What is the sequence generator transformation in informatica?
Under what condition selecting sorted input in aggregator may fail the session?