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 sqlite good enough for production?

992

How to call a javascript function from pl sql?

1139

What is the difference between microsoft access and sql?

1023

Can we insert data into view?

901

Is ms sql traffic encrypted?

923

How many types of privileges are available in sql?

1350

What is delimiter sql?

1004

What are the ddl commands?

1011

What is case function?

1040

Can two tables have same primary key?

976

How can we avoid duplicating records in a query?

982

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1168

What is clause in sql?

1108

how to convert character strings to dates? : Sql dba

1060

Is left join same as inner join?

1129