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

What is exception? What are the types of exceptions?

1073

What is #table in sql?

1098

How can I delete duplicate rows?

1017

What are pl/sql cursor exceptions?

1104

What is orm in sql?

1047

Write the command to remove all players named sachin from the players table.

1184

What are sql data types?

1025

What are the different sql languages?

1035

What does an inner join do?

1180

How do I quit sql?

957

What are the different schemas objects that can be created using pl/sql?

1028

What is the purpose of normalization?

1040

How to create a menu in sqlplus or pl/sql?

1123

How can we avoid duplicating records in a query?

982

discuss about myisam key cache. : Sql dba

1021