In a table, 4 person having same salary. How to get Third
person record only?
Answer Posted / mr.lee
id sal
101 1000
102 1000
103 1000
104 1000
Select Rn, id, Sal, From (
Select Rownum Rn, id ,Sal From Emp)
Where Rn = 3
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is rank transformation in informatica
How you prepared reports for OLAP?
What does cheating measurement mean?
How to use pmcmd utility command?
Can I use same Persistent cache(X.Dat) for 2 sessions running parallely? If it is not possible why?If yes How?
What is workflow? What are the components of the workflow manager?
What is lookup change?
What is Session and Batches?
Explain incremental aggregation in informatica
I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.
What is target designer and target load order?
Why do we need informatica?
How can you increase the performance in joiner transformation?
Define mapplet?
What is mapping debugger?