Hop it helps! Select sal from (select sal from emp order by sal desc w

write a query for the fifth highest salary?

Question Posted / sujit

Answer Posted / sujit

Hop it helps!

Select sal from (select sal from emp order by sal desc
where rownum<6);

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is dialect in database?

929

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

977

Define stored procedure?

968

What is the difference between a stored procedure and a query?

1034

What are different types of clusters present?

1023

what is tkprof tool and how it is used???

2770

Differentiate between unique key and foreign key?

953

What is the relationship that exists inside in E-R diagram?

1040

WHAT IS CARDINALITIES OF JOIN?

2314

What is a super key?

978

What is the difference between oracle and MS Access?

1018

Explain database partitioning. What is its importance?

1133

What is the difference between database and server?

940

Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

1396

How do you pass parameter in stored procedure?

1145