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 the use of an aggregator cache file?
Write the program through which the records can be updated?
explain about unit testing? in real time?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Briefly describe lookup transformation?
what is persistent lookup cahce?how to use and when to use this persistent lookup cahce?explain?
What do you understand by SOA of Informatica?
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Write the prerequisite tasks to achieve the session partition?
What is InformaticaPowerCenter?
What is the Rank index port in Rank transformation?
Explain the code page compatibility?
in reporting we add some new objects,how we get the count of the newly added objects to the report
i have a data in my source as a flat files what test i have to perform the next step can any body help to me
What are pre and post-session shell commands?