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

What is transaction control language (tcl)?

1187

Can we use distinct and group by together?

1107

What is dynamic query?

1036

how to decrement dates by 1 in mysql? : Sql dba

1077

Can you select everything, but 1 or 2 fields, without writer's cramp?

1041

Which join is default?

1017

What are schema-level triggers?

1155

How would you pass hints to the sql processor?

1041

what is not null constraint? : Sql dba

1078

What is sql and also describe types of sql statements?

1114

what is 'mysqlshow'? : Sql dba

1076

How do you create a unique index?

1094

How can you select unique records from a table?

1149

What are the topics in pl sql?

1024

How to change sql*plus system settings?

1112