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 do you tell what your machine name is and what is its IP address?

2073

Is there any function in oracle similar like group_concat of mysql?

1036

Explain the difference between a procedure and a function?

1143

How do I start tns listener?

1026

Does oracle partitioning improve performance?

967

What is MTTR advisor in Oracle?

1077

What is the sql query to concatenate column values from multiple rows in oracle?

1036

What is a dynamic performance view in oracle?

977

Why we use bulk collect in oracle?

1013

What are the different editions of oracle?

1090

Explain oracle insert into command?

1086

What is the scope of a local variable?

1044

What is integrity and what is constraint??Explain with example

2257

How to work with data objects interactively?

959

What is an Oracle index?

1634