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 nosql faster than sql?

1031

What are the types of optimization?

963

What is the use of partition by in sql?

997

What is sql*loader?

1200

What is mdf ldf and ndf?

1006

How do I run a pl sql program?

1133

How do you clear the screen in sql?

1077

Which query operators in sql is used for pattern matching?

972

Define commit?

1010

Can we use joins in subquery?

1168

What is natural join in sql?

998

Explain the uses of database trigger.

1119

How do I count records in sql?

1016

What is cross join sql?

925

Explain sql data types?

1107