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

What is pl sql package?

1069

How can you fetch first 5 characters of the string?

1059

Why is theta join required?

1185

What is the difference between left outer join and left join?

1032

What do you mean by table in sql?

1040

What is pl/sql language case sensitive?

1175

Explain commit, rollback and savepoint.

1050

What are all types of user defined functions?

1130

What is a data definition language?

1193

What are the types of variable use in pl sql?

1130

what is sql? : Sql dba

1064

Can we enter data in a table in design view?

1004

What are different types of sql?

1256

What are the disadvantages of not performing database normalization?

1212

What are the advantages of sql? Explain

1147