select top 1 colmn from table_name where colmn in (select top 2 colmn

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

Question Posted / rajkumar

Answer Posted / rajkumar

select top 1 colmn from table_name where colmn in
(select top 2 colmn from table_name where colmn is not
null order by colmn desc)

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain what is rdbms?

1017

What does pl sql developer do?

911

What is a procedure in pl sql?

1192

How to raise user-defined exception with custom sqlerrm ?

1115

Why having clause is used in sql?

957

what is 'mysqlimport'? : Sql dba

1015

How does sql*loader handles newline characters in a record? : aql loader

1021

What are few of the schema objects that are created using PL/SQL?

1013

what are the differences between char and varchar? : Sql dba

1056

How many tables can a sql database have?

958

what is the syntax for using sql_variant_property? : Transact sql

1023

Why commit is not used in triggers?

1023

What is server name sql?

1121

how to use case expression? : Sql dba

996

How do you delete a table?

1048