select* from (select rownum rank,ename,sal from emp order by sal desc) wh

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

Question Posted / srcreddy

Answer Posted / srcreddy

select* from
(select rownum rank,ename,sal from emp order by sal desc) where rank=5;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

dumps needed ASAP for - C2020-180 Cognos IBM Certification

2205

What is metric store database?

1003

What are the ways to import data into catalog?

1085

Define datastores in cognos?

955

How can you link a query to a data container manually in Report Studio?

2360

How do you Parametermap variables in Quiries?

2268

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

2047

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

1927

How to generate cubes in cognos?

974

What is the difference between group and associare?

1049

Can you define drill across?

983

What is Bitmap Index?

1052

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2443

i was asked what are the caluclations done by you in your report? plz give reply

2196

What are the advantages of using cognos sql?

1194