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

Which is the best graph database?

905

What is Object Oriented model?

970

What is difference between data and database?

1013

What are different types of joins used in?

1052

You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?

1170

how can you perform lookup range in lookup stage expalin in detail?

1879

Which three commands cause a transaction to end?

1002

What is odm in database?

999

Is it good to store images in database?

947

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

2270

Can you create a database in word?

987

issues involved in modeling and building data werahouses

1905

Which Statement would you use to remove the EMPLOYEE_Id_PK PRIMARY KEY constraint and all depending constraints from the EMPLOYEE table?

1064

How does non-cluster index functions?

1081

How default key is different from primary key?

986