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 range partitioning?

516

What is database white box testing and black box testing?

634

how to drop an existing index in mysql? : Sql dba

531

What's the difference between inner join and left join?

511

How does cross join work?

498

How is pl sql different from sql?

540

Is sql a programming?

543

tell us something about heap tables. : Sql dba

596

Is sqlite free?

532

Can we rollback delete command?

510

How many types of keys are there in sql?

550

How do I sort a table in sql?

587

Does pdo prevent sql injection?

520

does sql support programming? : Sql dba

603

What is the usage of when clause in trigger?

563