select max(sal) from emp where sal not in(select max(sal) from emp where

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

Question Posted / kumar sumit

Answer Posted / kumar sumit

select max(sal) from emp where sal not in(select max(sal)
from emp where sal not in(select max(sal) from emp))

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How can triggers be used for the table auditing?

1008

What are transaction and its controls?

967

what is text? : Sql dba

1006

What operating systems are supported by oracle sql developer?

902

What are the advantages of normalization?

1034

Where do we use pl sql?

942

What is difference between pl and sql?

990

Is sql a programming?

932

What is pl sql architecture?

919

What is the unique index?

1000

What are the uses of merge?

1116

How do you add a column to a table?

992

What is pl sql script?

975

What is the use of non clustered index?

925

Explain about various levels of constraint.

880