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 do I enable sql encryption?

1035

Why we use triggers in mysql?

995

Can delete statement be rollbacked?

991

What does partition by mean in sql?

969

what are all types of user defined functions? : Sql dba

1043

What is the difference between clustered and non-clustered index in sql?

1018

What is materialized view. What are different methods of refresh?

1394

How does postgresql compare to mysql?

1039

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1074

what are the different type of sql's statements ? : Sql dba

927

What is cursor and its types?

1080

What is package in pl sql with an examples?

1042

What does pl sql stand for?

1122

What is the difference between between and in condition operators?

1011

Can I join the same table twice?

1054