select max(sal) from emp_test where sal not IN(select max(sal) from em

how to get the second max val for every group in a table

Question Posted / abc

Answer Posted / abc

select max(sal) from emp_test where sal not IN(select
max(sal) from
emp_test group by deptno)group by deptno;

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Explain what are the characteristics of data files?

1031

How to store pictures on to the database?

923

Is there a combination of "like" and "in" in sql?

1007

Why use resource manager in Oracle?

1052

Explain the importance of .pll extension in oracle?

956

How to create an oracle database?

978

How to run create database statement?

979

What is bulk load in oracle?

1007

Does oracle partitioning improve performance?

947

How would you begin to troubleshoot an ORA-3113 error?

2025

What is Segment Advisor in Oracle?

1051

How to convert a string to a date in oracle database?

1002

What are a collation and state the different types of collation sensitivity?

1095

What are oracle functions?

976

How to store only time; not date and time?

960