how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
Answer Posted / amedela chandra sekhar
Select * from (select rownum as rno, emp.* from emp) where
rno in (1,3,5);
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What does “tail –f” command do and what is its use as an Informatica admin.
Can we get 1st record through Informatica(without sequence number).
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How can we store previous session logs?
Is it possible to create multiple domains on a single Informatica server?
What is a predefined event?
What are active transformations.
What is a joiner transformation and why it is an active one?
How can we remove the duplicates from flat file source?
How do you load first and last records into target table?
In informatics server which files are created during the session rums?
Separate from an archive server and a powerhouse?
How can you increase the performance in joiner transformation?
Enlist the differences between database and data warehouse.
What is blocking transformation?