Select salary from (select salary from employees order by salary desc) whe

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

Question Posted / abc

Answer Posted / abc

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

Is This Answer Correct ?

8 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How show all rows in sql?

975

what is a tablespace? : Sql dba

1007

define join and explain different type of joins? : Sql dba

900

What is consistency?

1063

Who developed sql?

962

What is a sql schema used for?

1031

How do you sort in sql?

954

What is the primary key?

879

Explain the rollback statement?

964

How many disk partitions should I have?

942

What is parallel hint?

1223

What is sql and also describe types of sql statements?

998

What is dml statement?

902

What is field delimiter?

991

What is the difference between rollback and rollback to statements?

1015