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

What are the two types of cursors in pl sql?

1089

What is server name sql?

1156

What is procedure function?

1072

What is schema in sql?

960

what are the 'mysql' command line options? : Sql dba

1082

Explain the difference in execution of triggers and stored procedures?

1028

Does sql require a server?

1023

What is procedure and function in sql?

1003

what is a table in a database ? : Sql dba

1055

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

990

Can procedure in package be overloaded?

1094

Can we call stored procedure in function?

971

What packages(if any) has oracle provided for use by developers?

5822

Is a table valued function object?

1028

What is cursor explain with example?

995