In a table, 4 person having same salary. How to get Third
person record only?
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
What is meant by query override?
How do we call shell scripts from informatica?
How can we handle two sessions in informatica?
What are the features of complex mapping?
What is the cumulative sum and moving sum?
Scheduling properties,whats the default (sequential)
What are the tuning techniques you applied during your last project
Where can we find the throughput option in informatica?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
What is sorter transformation?
Explain the difference between a data warehouse and a data mart?
What is meant by a domain?
How can we delete duplicate rows from flat files?
Explain the different lookup methods used in informatica?
How can you define user defied event?