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 can I test reports in cagnos?

1081

How to deploy from one server to another server?

2433

How to create a cube in Transformer? What is the process? Please mention process thank u

1702

What is the use of powerplay web viewer in cognos?

1030

how you migrate reports to cognos 8 from previous versions?

985

How create measures and dimensions?

1009

Source table has 5 rows. Rank in rank transformation is set to 10. How many rows the rank transformation will output?

1009

HI, If anybody is having C2020-625 - IBM Cognos 10 BI Data Warehouse Developer, kindly send the same to shiju.rajs@gmail.com. Thanks

1880

What is a Framework manager?

987

What are the advantages of shortcuts?

911

what is hints in cognos and where we use it.

2407

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

2032

Define metrics studio?

978

how to perform back drill through in cognos 8 what is the use of it

2467

What is the use of powerhouse?

990