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
- 21107 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
Explain scd type 3 through mapping.
What are the issues you have faced in your project? How did you overcome those issues?
How to extract sap data using informatica? What is abap? What are idocs?
What are the different transaction levels available in transaction control transformation?
Enlist the various types of transformations.
What is data caches/ index caches?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
What are the transformations that are not supported in mapplet?
What is the reusable transformation?
What is informatica powercenter repository?
WHAT IS EDM?WHAT IS THE USE IN INFORMATICA? chandumba2005@gmai.com
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What are roles and groups and benefits of using them?
Differentiate between router and filter transformation?
how to create user defined function (udf) in informatica
