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
What are the guidelines to be followed while using union transformation?
If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me
What is sorter transformation?
Enlist the advantages of informatica.
Can we change Dynamic to Static or Persistent cache? If so what happens?
What are the differences between oltp and olap?
What do you mean incremental aggregation?
How will the document be delivered to me?
Can we create multiple integration service on single repository?
Is stop and abort are same in informatica?
How to join three sources using joiner? Explain though mapping flow.
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What are mapplets?
What are the different ways to implement parallel processing in informatica?
How do you use reject loader.