select min(sal) from emp where sal in( select top 3 sal from emp order by

how to check the 3rd max salary from an employee table?

Question Posted / nagendra

Answer Posted / nagendra

select min(sal) from emp where sal in( select top 3 sal
from emp order by sal desc)

Is This Answer Correct ?

2 Yes

6 No

Please Help Members By Posting Answers For Below Questions

Does sql profiler affect performance?

1001

Is nosql relational?

948

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

1011

how would you enter characters as hex numbers? : Sql dba

993

What is a database trigger?

1078

What is the difference between partition and index?

997

what is the use of friend function? : Sql dba

1029

how can we destroy the cookie? : Sql dba

1017

What are the types of variables use in pl sql?

1049

What is PL/SQL Records?

1197

What are the parameter modes supported by pl/sql?

1117

What is an exception in PL/SQL? What are the two types of exceptions?

1318

what is csv? : Sql dba

1003

How you improve the performance of sql*loader? : aql loader

1020

Is progress software supports to ( pl/sql )?

1044