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

What do you mean by query optimization?

999

What is the difference between local variables and global variables?

1123

What is data definition language?

1088

How to change sql*plus system settings?

1051

What are the different set operators available in sql?

1023

What is data types in sql?

1007

Is mariadb nosql?

1040

what is sql profiler? : Sql dba

1038

what is subquery? : Sql dba

1132

What does the argument [or replace] do?

1076

What does varchar include?

946

How do I debug a stored procedure?

1111

How do you modify a table in sql?

1118

How does a self join work?

1109

How to get list of all tables from a database?

1154