Interested to Buy Any Domain ? << Click Here >> for more details...
how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 25426 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / siva reddy
display odd records
select * from emp where (rowid,1) in ( select
rowid,mod(rownum,2) from emp)
display even records
select * from emp where (rowid,0) in ( select
rowid,mod(rownum,2) from emp)
| Is This Answer Correct ? | 10 Yes | 5 No |
Post New Answer View All Answers
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
Where do we use mapping variables in informatica?
Explain how to import oracle sequence into informatica?
In development project what is the process to follow for an etl developer from day1
can anyone explain me about retail domain project in informatica?
What are the differences between joiner transformation and source qualifier transformation?
What is the difference between a repository server and a powerhouse?
Explain sessions. Explain how batches are used to combine executions?
During the running session, output files are created by informatica server. Enlist few of them.
How can you define user defied event?
What are mapplets?
Which is the t/r that builts only single cache memory?
Tell me about MD5 functions in informatica
What is incremental aggregation?
What is joiner transformation?
