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

what are the limitations of mysql in comparison of oracle? Mysql vs. Oracle. : Sql dba

903

Explain architecture of sql server notification services?

991

Is sql developer case sensitive?

945

What are the uses of sysdate and user keywords?

1054

What port does sql server use?

992

what is rdbms? : Sql dba

964

What is a data manipulation language?

968

what are local and global variables and their differences? : Sql dba

1010

Do stored procedures prevent sql injection?

920

Explain table and field in sql?

1020

Is trigger a stored procedure?

887

Mention what is the use of function "module procedure" in pl/sql?

1010

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1032

what is data manipulation language? : Sql dba

949

How to display the records between two range in Oracle SQL Plus?

1101