select salary from(select salary from emp order by salary desc)where rown

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

Question Posted / manjunath u

Answer Posted / manjunath u

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is a ddl command?

722

What is example of database?

701

Can we change the table name in sql?

706

What are predefined functions in sql?

712

What are different types of tables in sql?

700

What are instead of triggers?

791

How do I delete a trigger?

723

what tools available for managing mysql server? : Sql dba

745

what is bcp? When is it used?

772

Does a user_objects view have an entry for a trigger?

757

What is cursor and why it is required?

795

does sql support programming? : Sql dba

797

how to use myisamchk to check or repair myisam tables? : Sql dba

711

What is the difference between alter trigger and drop trigger statements?

799

Which are the different types of indexes in sql?

749