What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / sbvp
select * from table name where sal in ( select * from
(select distinct sal from tablename order by sal desc)
where rownum<=&n);
if there is any another query plz tell me r mail me
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
Design time, run time. If you don't create parameter what will happen
Differentiate between sessions and batches?
What are the components of the workflow manager?
What is a transaction control transformation?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
What are the different ways to implement parallel processing in informatica?
In informatica workflow manager, how many repositories can be created?
Plz can any one say me how to get the informatica certification materials and dumps
What are the different clients of powercenter?
What does reusable transformation mean?
Explain sessions and how many types of sessions are there?
What is Session and Batches?
I have a mapping loading 100 records and it failed on 20th record. how to recover it without changing anything.(in prod where we don't have any access).. (the session should should start from 21 record)
Mention few advantages of router transformation over filter transformation.
What is transformation?