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

What is snowflake sql?

1130

How do I run a program in pl sql?

1055

What is a delimiter in sas?

1130

What is cursor and why it is required?

1256

What are the different dcl commands in sql?

1234

What are the types of subqueries?

1103

Can I create table without primary key?

1044

What does desc stand for?

1125

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1245

what is self-join? : Sql dba

1244

Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?

1065

Which one is better sql or oracle?

1015

How to create an array in pl/sql?

1123

what is the difference between delete and truncate commands? : Sql dba

1119

What is raw datatype in sql?

1109