In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / sanju
select * from (select salary.*,rownum r from salary where
sal=(select sal from salary group by sal having count(sal)
=4)) where r=3
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Differences between connected and unconnected lookup?
State the limitations where we cannot use joiner in the mapping pipeline?
Tell me about Propagate functions in informatica
What all are steps in up gradation of Informatica server?
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.
Why update strategy and union transformations are active?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
which one is better performance wise joiner or look up
difference between repository database and repository service?
Whats the difference between informatica powercenter server, repositoryserver and repository?
What are the tuning techniques you applied during your last project
What are roles and groups and benefits of using them?
Define Pmrep command?
Did u used latest transformations of 8.6.0? for what?
What is the surrogate key?