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
Different circumstance which drives informatica server to expel records?
What are the new features of informatica 9.x at the developer level?
What is a mapplet/worklet in informatica?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
Explain the tuning lookup transformation - informatica
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
Hi, There is a session in my workflow which is running for a long time, atlast we found the cause is the missing index. My session is running via a stored procedure. Can I create an Index on the table which the stored procedure is using while my session is running? Please suggest. My Informatica version is PC 8.0.6 My Oracle APPS is 11.5.3. Thanks,
How you prepared reports for OLAP?
What is standalone command task?
Define mapplet?
How many ways a relational source definition can be updated and what are they?
Which is the t/r that builts only single cache memory?
What is meant by LDAP users?
How big was your fact table
What is informatica etl tool?