SELECT empno, sal FROM ( select empno, sal, ROW

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

Question Posted / hashmatulla baig

Answer Posted / hashmatulla baig

SELECT empno, sal
FROM
(
select empno, sal, ROW_number() OVER (order by sal desc) R
from emp
order by sal desc
)
WHERE R = 5;

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

how you provide security to reports? How you provide security to packages ?

1059

What are the ways to import data into catalog?

1078

What are the services provided in cognos 8?

1026

How do you call a store procedure within a transformation?

994

i have one file i saved in csv how can i take these file into framework manager

2077

What is difference between informatica power mart and power center?

1002

Explain the characteristics of cognos?

1040

What is the difference between set functions and filter function in dimensional data?

2897

Can anyone give me the url for cognos forum which is similar to forumtopics.com/busobj for business objects?

2039

What is zero-foot print?

1015

What is Bitmap Index?

1029

describe the starschema grouping ?how can i add a new column for existing report ,when it is not present even in model & dataabase?

2309

What is a Pivot?

1134

What is the metric store database?

961

whats the difference between previous version of cognos and cognos 8 BI?

5527