select distinct(a.sal) from emp a where 2=(select count(distinct(b.sal)) fr

Query for second maximum salary in each in each department

Question Posted / sampath pallerla

Answer Posted / sampath pallerla

select distinct(a.sal) from emp a where 2=(select count(distinct(b.sal)) from emp b where a.sal<=b.sal);

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

Does truncate free space?

1067

What found sql?

995

What is group function in sql?

1069

What are all the common sql functions?

1086

What are the main features of cursor?

1114

What is a pragma statement?

1338

What are the dml statements?

1198

How do I upgrade sql?

1051

What is set transaction?

1090

Can a view be mutating? If yes, then how?

1093

Can ddl statements be used in pl/sql?

1195

What is parallel hint?

1419

How do I run a pl sql program?

1193

How to Declare Fixed Length String Value In PL SQL

1209

What is difference between sql and mysql?

1201