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

Can you define framework manager?

1037

Can you define materialized view?

1050

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

2361

What is cognos powerhouse?

1026

How to a create header dynamically in a crosstab report in cognos 8.1?

2441

What you mean by drill across and what is the difference between drill through, drill across?

1028

How to Reset Pagenumbers in one report.

2673

What is main difference mapplets and mapping?

1202

Can you define cube?

1035

What are all the types of gateway used in Cognos?

1031

hi all i am searching for cognos jobs pls inform about the jobs to:santosh.koora@gmail.com

2367

What are query items?

1027

What is drill down and slicing and dicing whats the difference between them?

1073

How to join multiple db in catalog?

1018

explain how to create powerplay reports?

1020