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

How can I make sql query run faster?

559

What is a Mapplet?

643

How is pl sql different from sql?

546

How many types of keys are there in sql?

554

What is a sql*loader control file?

618

What is dml and ddl?

524

how are mysql timestamps seen to a user? : Sql dba

563

What is case function?

599

Explain about various levels of constraint.

523

What is 19 null in sql?

534

Does truncate release storage space?

559

What are the types of queries in sql?

519

Does sql backup shrink transaction log?

552

What are the qualities of 2nf?

544

what are all types of user defined functions? : Sql dba

547