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 all types of user defined functions? : Sql dba

1029

What is the most restrictive isolation level? : Transact sql

1068

What is a parameter query?

1058

What is exception? What are the types of exceptions?

1060

Define a temp table?

1004

Can we perform dml in function?

1050

How to Declare Fixed Length String Value In PL SQL

1135

What is delimiter in pl sql?

1038

Explain the insert into statements in sql?

983

Do prepared statements prevent sql injection?

933

What is cascade in sql?

946

Why are cursors used?

1104

What does (*) mean in sql?

939

Can we use two order by clause in query?

948

How many rows can sqlite handle?

1092