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 do you mean incremental aggregation?
What do you mean by channel change?
Do you find any difficulty while working with flat files as source and target?
How to handle decimal places while importing a flatfile into informatica?
server hot-ws270 is connect to Repository B. What does it mean?
What are active transformations.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
tell me the rules and responsblites in our project(my project is development)
What do you understand by a term domain?
whats the logic to load the lower level of granularity of data to fact table.
Can u generate reports in Informatica?
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
How to generate sequence numbers using expression transformation?
What are the types of caches in lookup?
What are ETL Tools?