select rownum as rank,name,sal from ( select name,sal from employees orde

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

Question Posted / rakesh

Answer Posted / rakesh

select rownum as rank,name,sal
from
( select name,sal from employees order by sal desc)
where
rownum=5

Is This Answer Correct ?

3 Yes

7 No

Please Help Members By Posting Answers For Below Questions

How to apply securities for reports in cognos connection?

2533

-----------------What is Direct and Conventional loading?

2163

What is a Pivot?

1134

Which studio is used to create reports?

1106

5. Which type of report you build more, list, crosstab or chart and why?

2014

What is defined as Query studio?

1093

tell me two or three issues from client side and how to solve those issues?

2160

What are types of batch available in cognos?

966

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

2353

Can you explain new content durability?

1019

What is called cognos reporting tool?

1046

What do you understand by the term 'model durability'?

1011

What is catalog and types of catalogs in cagonos and which is better?

996

What is defined as catalog and types of catalogs in Cognos?

1129

Write various indexes used in cognos?

965