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

Where do you use decode and case statements?

994

Give the advantages and disadvantages of clusters.

1051

What is literal?

1007

What is the dynamic sql in oracle?

1073

Can we save images in a database and if yes, how?

1065

How to convert character types to numeric types?

1134

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2276

How to use subqueries with the exists operator in oracle?

1027

What is object data modeling?

969

Can I create users through internet explorer in oracle 10g?

1084

Explain coalesce function?

1207

How to shutdown your 10g xe server from command line?

1086

How to drop an existing view in oracle?

946

Explain the importance of .pll extension in oracle?

1012

How to create a table index?

1151