select * from((select * from emp order by sal desc where rownum<=5)MINUS

Write a SQL query which should fetch the 5th maximum salary
of an employee from the table?

Question Posted / balanandam

Answer Posted / balanandam

select * from((select * from emp order by sal desc where rownum<=5)MINUS(select * from emp order by sal desc where rownum<=4))

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the use of powerhouse?

611

how to test reports in cognos?

582

What is the use of cognos decision stream?

660

What errors and types of errors you faced in Cognos ReportNet?

3478

What are the advantages of using cognos sql?

651

hi friends pls forward impropmtu interview question

1679

--------------Diff b/w ODS and OLAP?

2750

What are the different uses of a repository manager?

599

What are the types of studio present in Cognos?

609

How to do Performence Tunning in Cognos Reports?

2066

Can you define snapshot?

549

What is meant by alternate drill down with ex?

619

What are the components used in web tier?

529

Define the cognos reporting tool?

543

How can we Maintain the Cube Security by Category level and Dimension level ?

1949