select salary from(select salary from(select distinct salary from employees

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

Question Posted / arun

Answer Posted / arun

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

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is a temporal table?

930

What is the difference between the conventional and direct path loader? : aql loader

1152

What is informix sql?

976

What are the types of join and explain each?

1047

What is trigger in sql and its types?

1057

What is trigger in flip flop?

1007

what is a constraint? Tell me about its various levels. : Sql dba

986

What is a schema? How is it useful in sql servers?

1120

Can we use ddl statements in stored procedure sql server?

1009

What is normalization in sql?

1012

Explain architecture of sql server notification services?

1060

How to connect a sql*plus session to an oracle server?

1128

What is a dynamic query?

1022

What is the least restrictive isolation level? : Transact sql

1068

Write a sql select query that only returns each name only once from a table?

1014