Select sal from salary_tbl where rownum <= 2 order by sal desc;

how to retrieve the top 2 salaried persons from a database?

Question Posted / mamta

Answer Posted / mamta

Select sal
from salary_tbl
where rownum <= 2
order by sal desc;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you do multiple joins in sql?

550

How do I create a sql script?

542

Are stored procedures faster than dynamic sql?

535

What is ttitle and btitle?

579

What is a native sql query?

499

What is sqlcontext?

553

Is primary key clustered or nonclustered?

568

Where do we use pl sql?

556

how to use in conditions? : Sql dba

514

What is a composite primary key?

585

what are the properties and different types of sub-queries? : Sql dba

510

how to include numeric values in sql statements? : Sql dba

565

what is oracle database ? : Sql dba

562

What is interval partition?

546

What is the basic form of sql query?

499