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

Which are sql * plus commands?

714

What is input buffer in sql*plus?

825

What is server name sql?

803

What is the starting oracle error number?

757

Is a table valued function object?

759

What is trigger and stored procedure in sql?

752

Which one is better subquery or joins?

775

What is file based approach?

663

Where do we use pl sql?

724

What is time based sql injection?

688

How do you copy a table in sql?

753

Is clustered index a primary key?

691

What are analytical functions in sql?

731

What is nvarchar in sql?

715

what is the use of double ampersand (&&) in sql queries?

820