What is the query to find nth highest salary?
What is the use of cursors?
- 8 Answers
- 18786 Views
- Keane India Ltd, I also Faced
- E-Mail Answers
Answer Posted / sbvp
select * from table name where sal in ( select * from
(select distinct sal from tablename order by sal desc)
where rownum<=&n);
if there is any another query plz tell me r mail me
| Is This Answer Correct ? | 2 Yes | 6 No |
Post New Answer View All Answers
What are the components of workflow manager?
Explain joiner transformation in informatica
What is a rank transform?
What are pre and post-session shell commands?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
When do you use sql override in a lookup transformation?
Explain lookup transformation source types in informatica
What is rank transformation in informatica
What are the basic requirements to join two sources in a source qualifier transformation using default join?
update strategy transformation in informatica
Quickly characterize reusable change?
What is an active transformation?
How to extract sap data using informatica? What is abap? What are idocs?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
