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

Is not equal in sql?

752

Can a foreign key be a duplicate?

680

what are the drivers in mysql? : Sql dba

736

how many ways we can we find the current date using mysql? : Sql dba

810

what is offset-fetch filter in tsql? : Transact sql

715

What is an index in sql with example?

710

What do you mean by table in sql?

696

Is join and inner join the same?

724

Do we need commit after truncate?

814

Explain the structure of pl/sql in brief.

792

What does a pl/sql package consist of?

719

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2297

What is a primary key called that is made up of more than one field?

1026

What are different sql data types?

685

What are the two types of exceptions in pl/sql?

733