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 is dba in sql? : SQL DBA

1045

What is crud sql?

990

Is time a data type in sql?

911

What is coalesce sql?

1004

What is forward declaration in pl sql?

1086

What do you know by pl/sql cursors?

1107

When do we use triggers?

1083

What is the difference between having and a where in sql?

1110

Which kind of parameters cannot have a default value in pl sql?

1150

Which type of cursor is used to execute the dml statement?

960

What is the difference between clustered and non-clustered index in sql?

1017

What are the differences between implicit and explicit cursors?

1071

How you can copy a file to file content and file to pl/sql table in advance pl/sql?

1149

Does normalization improve performance?

1041

Mention what does the hierarchical profiler does?

1093