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

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

Question Posted / seetharam

Answer Posted / seetharam

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

Is This Answer Correct ?

3 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is schema in sql example?

824

What normalization means?

709

how to decrement dates by 1 in mysql? : Sql dba

760

What is exit statement?

743

Why do we use procedures in pl sql?

719

What is foreign key sql?

746

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

868

What does stand for in sql?

715

How do sql databases work?

710

what tools available for managing mysql server? : Sql dba

745

What is attribute indicator in pl sql?

717

Is left join same as join?

729

what is the functionality of the function htmlentities? : Sql dba

692

Explain cursor types?

750

What is an oracle stored procedure?

784