What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / venky
select * from emp e where &n=(select count(distinct(b.sal))
from emp b where e.sal=b.sal);
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Can we change Dynamic to Static or Persistent cache? If so what happens?
How many types of sessions are there in informatica.please explain them?
What is workflow? What are the components of the workflow manager?
Performance tuning in UNIX for informatica mappings?
Write the different tools in the workflow manager?
What is the meaning of up gradation of repository?
How can you increase the performance in joiner transformation?
What you know about transaction control transformation?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is the Rank index port in Rank transformation?
What is the maplet?
What is substr in informatica?
Differences between connected and unconnected lookup?
Can we create two repositories on same database instance in oracle?
What is the difference between informatica 7.0 and 8.0?