What is the query to find nth highest salary?
What is the use of cursors?
Answer Posted / biswa
select distinct(e1.sal) from emp e1 where &n=(select count(distinct(e2.sal)) from emp e2 where e1.sal <=e2.sal)
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is expression transformation?
What is the reusable transformation?
wf dont have integration severances how you can run?
Explain the types of transformations?
lookup transformation with screenshots
can anyone suggest best free Talend data integration training online
How to improve the performance of a session using sorter transformation?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
What is a router transformation?
Differentiate between Load Manager and DTM?
Can anyone tell me the new features in Informatica 9 Version?
Explain the shared cache and re-cache?
What is an unconnected transformation?
If the source has duplicate records as id and name columns, values: 1 a, 1 b, 1 c, 2 a, 2 b, the target should be loaded as 1 a+b+c or 1 a||b||c, what transformations should be used for this?
What are the new features of informatica 9.x at the developer level?