how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 21096 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / punyaslok
(select * from emp)-(select rownum,emp.* from emp order by
mod(rownum,2);
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
How many numbers of sessions can one group in batches?
How to Create a folder using pmrep command?
During the running session, output files are created by informatica server. Enlist few of them.
What is the procedure for creating independent data marts from informatica 7.1?
According to his methodology what all you need before you build a datawarehouse
what is the size of your data warehousing?
What is primary and backup node?
Design a mapping to load the cumulative sum of salaries of employees into target table?
How to elaborate tracing level?
What is the need for an etl tool?
What is target designer and target load order?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
What are different types of transformations available in informatica?
