select salary from (select distinct salary from employees order by salar

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

Question Posted / ajay dond

Answer Posted / ajay dond

select salary from (select distinct salary from employees
order by salary desc)
where rownum<6

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Which join is default?

899

Is left join faster than inner join?

1065

What do you mean by query optimization?

953

How to avoid duplicate records in a query?

952

What is a record in a database?

995

Why do we use cursors?

921

Why do we need view in sql?

934

What is the difference between cluster and non-cluster index?

1050

what is a field in a database ? : Sql dba

991

Is it possible to include an insert statement on the same table to which the trigger is assigned?

959

What is implicit cursor in pl sql?

1031

What is a sql instance vs database?

1038

What is left inner join in sql?

986

What are the properties of a transaction?

1073

Does sql view stored data?

901