write a query for the fifth highest salary?

Answer Posted / chethan

select Salary from ( select salary from emp order by desc) as employee where rownum = 5;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of TNS?

655


What is a trace file?

630


how to send multiple records which matches all the condition in the lookup transformation ? (if lookup matches the codition for duplicate values)

1583


how to configure oracle 10g in java1.5 and tell me know how to set class path in system?

1581


WHAT IS CARDINALITIES OF JOIN?

1921






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

2370


What is a super key?

622


What is sharded database?

507


aht is the difference b/w network & hierarchial & relational dbms????

1769


On startup, the transaction log of a database has filled and recovery has suspended, what can I do?

550


How do database connections work?

494


what is data access layer?

1974


i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name

1659


What do you mean by database?

588


Explain natural key?

615