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

define sql update statement ? : Sql dba

1154

Explain the steps needed to create the scheduled job?

1086

What is rank () in sql?

995

How do I trace sql profiler?

1039

What are the limitations of sql express?

1114

What is pl sql code?

1098

How to get unique records from a table?

1019

How do you declare a user-defined exception?

1070

What is sql exception?

1008

What makes a good primary key?

1093

How many sql databases can you have on one server?

1145

How do I view tables in mysql?

1027

What is sqlcontext?

1138

How do I truncate a sql log file?

1123

What are the different type of joins in sql?

995