select sal from (select sal from emp order by val desc) where rownum <

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

Question Posted / debanjan rudra

Answer Posted / debanjan rudra

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

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is data control language? : Sql dba

589

what are sequences

1100

What do you mean by rowid?

541

What is inner join in sql?

587

What does over partition by mean in sql?

536

What is mutating error?

511

What does select top 1 do in sql?

544

What are literals in sql server?

540

What is the difference between rollback and rollback to statements?

586

Is sqlite thread safe?

610

What is the use of %rowtype?

537

Can we use pl sql in sql server?

543

what are the limitations of identity column? : Transact sql

608

how to present a past time in hours, minutes and seconds? : Sql dba

570

is it possible to pass an object or table to a procedure as an argument?

576