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
- 21185 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
Enlist few areas or real-time situations where informatica is required.
what is SDLC way of code development?
Is there any way to read the ms excel datas directly into informatica?
How to generate sequence numbers using expression transformation?
Mention some types of transformation?
Which are the different editions of informatica powercenter that are available?
Define Pmrep command?
How to create Target definition for flat files?
How can repository reports be accessed without sql or other transformations?
Reusable transformation and shortcut differences
Define sessions in informatica etl?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
Informatica settings are available in which file?
How can you validate all mappings in the repository simultaneously?
How to update a particular record in target with out running whole workflow?
