select min(column_name) from table where column in(select top n column

Find out the 3rd highest salary?

Question Posted / anjali

Answer Posted / anjali

select min(column_name) from table where column in(select
top n
column_name from table order by column_name desc)

Is This Answer Correct ?

4 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Why do we use procedures in pl sql?

1039

Can we change the table name in sql?

939

Which operator is used in query for pattern matching?

1089

Explain what is a database?

1085

How do I run a pl sql procedure in sql developer?

968

Differentiate pl/sql and sql?

1064

Name the operator which is used in the query for pattern matching?

945

what is sp_pkeys? : Transact sql

1155

How do I kill a query in postgresql?

1121

what is unique key constraint? : Sql dba

1035

Why functions are used in sql?

990

How do I use google cloud in sql?

1084

what is data control language? : Sql dba

1024

how tsql statements can be written and submitted to the database engine? : Transact sql

995

Can we use rowid as primary key?

987