Select salary from (select salary from employees) where rownum <=2;

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

Question Posted / unknown

Answer Posted / unknown

Select salary from (select salary from employees) where
rownum <=2;

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What is sqlerrm?

987

What is prepared statement in sql?

1104

What is java sql package?

1145

What is normalization sql?

1118

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

1063

State few characteristics of pl/sql?

1025

What is the maximum number of triggers, you can apply on a single table?

1048

What are the types of sql commands?

1162

which types of join is used in sql widely? : Sql dba

1032

How do I view output in sql developer?

1126

What are the different types of a subquery?

1106

What are tables and fields?

1087

Explain the steps needed to create the scheduled job?

1092

discuss about myisam key cache. : Sql dba

1072

How do I start sql profiler?

1048