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

Is merge a dml statement?

921

Define tables and fields in a database

1080

define sql update statement ? : Sql dba

1048

what is the difference between primary key and unique key? : Sql dba

968

Can you join views in sql?

896

What are the uses of merge?

1116

What is the starting oracle error number? What is meant by forward declaration in functions?

937

What is sql profiling in oracle?

992

What port does sql server use?

985

What is the limitation on the block size of pl/sql?

935

How do I remove sql plus from windows 10?

1022

What is character functions?

1014

What is a nested table in word?

909

How many aggregate functions are available there in sql?

928

How is data stored in sql?

1001