select max(salary) from emp where salary in(select salary from emp where

Query for second maximum salary in each in each department

Question Posted / nancy singhal

Answer Posted / nancy singhal

select max(salary) from emp where salary in(select salary
from emp where salary not in(select max(salary) from emp));

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How can you know that statistics should be updated?

1025

Is natural join and inner join same?

854

What is difference between table and view?

978

What is the difference between the conventional and direct path loader? : aql loader

1112

How do I run a pl sql program?

1066

Why do we use subquery?

944

what is table? : Sql dba

993

What is difference between rank () row_number () and dense_rank () in sql?

1052

Does view store data in sql?

902

What is pl sql package?

993

What is case function?

989

What is graph sql?

938

How can I make sql query run faster?

963

How much does sqlite cost?

986

Which certification is best for sql?

940