select salamt from ( select rownum n,salamt from ( select d

write a query for the fifth highest salary?

Question Posted / bezalel

Answer Posted / bezalel

select salamt from
(
select rownum n,salamt from
(
select distinct salamt from emp order by salamt desc
)
)
where n=5

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain natural key?

1124

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2646

Is hive a database?

942

What is the difference between specialization and generalization?

1025

How much does it cost to build a database?

1025

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

2105

Does facebook use graph database?

1030

What is the DIF format and when we will use in teradata

2488

Explain entity ?

1028

How default key is different from primary key?

1039

What is aws documentdb?

1047

what is the role of auditor in auditing data oriented applications?

2390

Explain the record term used in database.

1071

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

1024

How to implement database security?

966