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


Please Help Members By Posting Answers For Below Questions

What is meant by query override?

635


How do we call shell scripts from informatica?

599


How can we handle two sessions in informatica?

616


What are the features of complex mapping?

647


What is the cumulative sum and moving sum?

756






Scheduling properties,whats the default (sequential)

1468


What are the tuning techniques you applied during your last project

1565


Where can we find the throughput option in informatica?

600


what are the fact table & dimensional table in pharmaceutical and hospotal related products???

1697


What is sorter transformation?

583


Explain the difference between a data warehouse and a data mart?

600


What is meant by a domain?

630


How can we delete duplicate rows from flat files?

742


Explain the different lookup methods used in informatica?

587


How can you define user defied event?

622