Interested to Buy Any Domain ? << Click Here >> for more details...
In a table, 4 person having same salary. How to get Third
person record only?
- 15 Answers
- 21184 Views
- I also Faced
- E-Mail Answers
Answer Posted / srikanth
id sal
101 1000
102 1000
103 1000
104 1000
select id, sal from emp where rownum<=3
minus
select id, sal from emp wwhere rownum<=2;
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
How to generate sequence numbers using expression transformation?
What are the types of lookup transformation?
How can we update a record in the target table without using update strategy?
Can you generate sequence numbers without using the sequence generator transformation?
What are session parameters ? How do you set them?
What is rank index in rank transformation?
Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?
Suppose we do not group by on any ports of the aggregator what will be the output?
What is the need of an ETL tool?
How can we use mapping variables in informatica?
How do you update the records with or without using update strategy?
What is meant by incremental aggregation?
Tell me about MD5 functions in informatica
Explain the pipeline partition with real time example?
What is native users?
