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

How many row comparison operators are used while working with a subquery?

973

What is a left join?

885

What is the unique index?

1000

write an sql query to find names of employee start with 'a'? : Sql dba

964

how to get help information from the server? : Sql dba

874

How to read xml file in oracle pl sql?

859

What types of commands can be executed in sql*plus?

1048

What is java sql package?

1023

what is transaction? : Sql dba

958

What are the benefits of triggers?

1119

Mention what pl/sql package consists of?

935

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2169

Is it possible to update views?

912

How many postgresql users are there, worldwide?

989

What are the different types of triggers?

1051