select sal from (select rownum,sal from emp order by sal desc) where row

how to retrieve the top 3 salaries of the table using rownum

Question Posted / akki julak

Answer Posted / akki julak

select sal from (select rownum,sal from emp order by sal
desc)
where rownum<4;

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What are reports usually used for?

564

List the ways to get the count of records in a table?

505

What is data type in database?

543

Explain the the update statement in sql?

570

How many joins in sql?

551

What is the location of pre_defined_functions.

644

Can %notfound return null after a fetch?

586

how to install mysql? : Sql dba

580

How to select the Nth maximum salary from Table Emp in Oracle SQL Plus ?

596

What is the difference between having and a where in sql?

570

Explain the working of primary key?

604

How do you create an update query?

520

What is the file extension for sql database?

515

Does sql profiler affect performance?

553

Where not exists in sql?

503