In a table, 4 person having same salary. How to get Third
person record only?

Answer Posted / pooja

hi all,
suppose 4 emp geting same sal as 4000... select * from emp
where sal=4000 and/having rowid=3

Is This Answer Correct ?    0 Yes 14 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an active transformation?

739


What is confirmed fact in dataware housing?

5912


Implementation methodology

1348


Explain informatica architecture - version 8 / 9

757


What is an expression transformation?

703






Tell me any other tools for scheduling purpose other than workflow manager pmcmd?

878


What are the different ways to implement parallel processing in informatica?

972


what are 3 tech challenges/ common issues you face?

1980


What are the conditions needed to improve the performance of informatica aggregator transformation?

684


Please let me know how to make Data masking in informatica..

1342


Why is sorter an active transformation?

758


How we can create indexes after completing the loan process?

838


What is a repository manager?

739


Explain load alternative records / rows into multiple targets - informatica

802


What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?

2008