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
What are the components of workflow manager?
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
Explain what transformation and how many are there in informatica?
What is the session task and command task?
What happens when a session fails and you click on recover?
Why sorter is an active transformation?
what is degenerated dimension?
what is Active lock explain
How can we use mapping variables in informatica? Where do we use them?
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
Differentiate between a database and data warehouse?
Write the different tools in the workflow manager?
Have you worked with/created Parameter file
Clarify the utilization of aggregator cache record?
How to create the source and target database connections in server manager?