select * from (select sal from emp order by desc) emp where rownum = 5

write a query for the fifth highest salary?

Question Posted / aravind

Answer Posted / aravind

select * from (select sal from emp order by desc) emp where
rownum = 5

Is This Answer Correct ?

6 Yes

14 No

Please Help Members By Posting Answers For Below Questions

Explain various types of locks in a transaction? Which is better and why?

1081

Explain partial key?

1141

What are the various ways to execute a query in teradata?

2655

What does specialization in DBMS mean?

1202

What is sharded database?

1012

What are database connection details?

1223

can we delete autodiff back up that we have set through sql server agent.

2252

What is global database name?

1040

What is the advantage of varchar2 over char?

1307

What is ole db source in ssis?

1049

What is the role of tester in discovery(in Checklist)?

2015

Write a query to get maximum and second maximum in oracle?

1099

What is the importance of database partitioning?

1100

can u combine pipeline parallelism and partition parallalism? how and whan?

2376

What are indexes in oracle?

1132