select salery from (select salery from emp order by salery desc) where ro

Write a query to find five highest salaries from EMP table.
(there is a column SALARY)

Question Posted / kishore

Answer Posted / kishore

select salery from (select salery from
emp order by salery desc) where rownum <=5 ;

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is dynamic query?

732

what are the differences between char and nchar? : Sql dba

797

What are few of the schema objects that are created using PL/SQL?

733

Can ddl statements be used in pl/sql?

795

Can we use delete in merge statement?

735

explain the difference between myisam static and myisam dynamic. : Sql dba

705

Can we create foreign key without primary key?

705

What are pl sql procedures?

701

Do we need commit after truncate?

815

Is sql workbench free?

712

How to know the last executed procedure?

809

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

704

What are the possible values that can be stored in a boolean data field?

719

What is thread join () in threading?

735

Explain architecture of sql server notification services?

787