What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / tina
select min(sal)
from tablename
where sal in
(select top n-1 sal from tablename order by sal desc)
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What are the different types of transformation available in informatica.
draw informatica architecture 8.6 ?
What do you mean by enterprise data warehousing?
How can you differentiate between powercenter and power map?
What is target load order?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
what is the hint? how to use it to reduce the query processing in program?
what are the best practices to extract data from flat file source which are bigger than 100 mb memory?
What are the different ways to implement parallel processing in informatica?
What is the difference between Active and Passive transformation?
How union transformation is used?
What are the tuning techniques you applied during your last project
Please let me know how to make Data masking in informatica..
What are the different lookup cache(s)?
What is informatica metadata and where is it stored?