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

How do I run a sql query?

969

What is sql stand for?

947

How do I create a sql script?

1052

What is a join query?

908

Describe types of sql statements?

994

Why we use triggers in mysql?

938

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

916

Which language is used in sql?

992

what is the syntax used for partition in tsql? : Transact sql

960

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1006

What does cursor do in sql?

971

Why do we need cursor in pl sql?

1080

What are the different types of database management systems?

951

What is trigger with example?

1015

What is a subquery in sql?

977