how will u get 1 and 3rd and 5th records in table what is
the query in oracle please help me
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
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How big was your fact table
what is the difference between informatica6.1 and infomatica7.1
What is the difference between SOURCE and TARGET BASED COMMITS? What are the deliverables?in your project?
Explain the types of transformations?
Make a note of the quantity vaults made in informatica?
What is the use of transformation?
What is an active transformation?
What is persistent lookup cache?
What is an Integration service in Informatica?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Mention few advantages of router transformation over filter transformation.
Explain the different lookup methods used in informatica?
Enlist the tasks for which source qualifier transformation is used.
What is a surrogate key?