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

How to test null values?

1154

How will you write a query to get a 5th rank student from a table student_report?

1918

What happens to indexes if you drop a table?

1222

How to check the server version in oracle?

1138

What is a nested table and how is it different from a normal table?

1101

How many file formats are supported to export data?

1263

How to export your own schema?

1048

What is a parameter file in oracle?

1185

What is a sub query? What are its various types?

1270

How do I reset a sequence in oracle?

1144

Explain the use of analyse option in exp command.

1187

How to count groups returned with the group by clause in oracle?

1118

How to use like conditions in oracle?

1111

What is save point in oracle database?

1361

Calculate difference between 2 date / times in oracle sql?

1097