Interested to Buy Any Domain ? << Click Here >> for more details...
What is the query to find nth highest salary?
What is the use of cursors?
- 8 Answers
- 21217 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
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
What are the different types of repositories created using informatica?
What is joiner transformation in informatica?
Explain pushdown optimization $pushdownconfig parameter - informatica
Explain the difference between mapping parameter and mapping variable?
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
What are the components of the workflow manager?
What is the commit type if you have a transaction control transformation in the mapping?
How identifying bottlenecks in various components of informatica and resolving them?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
Explain transaction control transformation in informatica
where to store informatica rejected data? How to extract the informatica rejected data?
As union transformation gives UNION ALL output, how you will get the UNION output?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
which one is better performance wise joiner or look up
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
