how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
- 16 Answers
- 22022 Views
- Cap Gemini, IBM, I also Faced
- E-Mail Answers
Answer Posted / sandipana
select rownum as rank,emp_id,sal from(select
lastname,salary from employees orderby salary desc)
where rownum IN(1,3,5);
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the different lookup methods used in informatica?
What is the Rank index port in Rank transformation?
Explain pushdown optimization $pushdownconfig parameter - informatica
Whats there in global repository
What is meant by target load plan?
What is a grid in Informatica?
What is a filter transformation and why it is an active one?
What is Session and Batches?
Explain joiner transformation in informatica
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
What is option by which we can run all the sessions in a batch simultaneously?
What is a sequence generator transformation?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
if we have a delimiters at unwanted places in a flat file how can we over come those.
What is Index Caches size?
