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

What the various ways to tune a teradata query

3203

What is database bounce?

986

What is difference between server and database?

1019

Can a database table exist without a primary key?

888

what is transaction state, buffer management, shadow paging

3377

What is the difference between primary key, foreign key and candidate key?

1053

What are different types of resources?

953

where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1974

What is database and its types?

949

What are the tools used for backup and ticketing?

956

HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2583

What is the best database?

940

What are the disadvantages of views in a database?

989

What is table scan and index scan?

1068

Why do we need distributed database?

936