select * from emp e1 where 2 =(select count(distinct(sal)) from emp e2 wher

Query for second maximum salary in each in each department

Question Posted / akula

Answer Posted / akula

select * from emp e1 where 2 =(select count(distinct(sal)) from emp e2 where e1.dno=e2.dno and e1.sal<=e2.sal);

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

Which join is like an inner join?

1021

what is a constraint? : Sql dba

1151

Is it possible to link two groups inside a cross products after the cross products group has been created?

1002

What is a pragma statement?

1262

What is indexes?

1054

What is the difference between database trigger and stored procedure?

1069

Is sql microsoft?

1043

Explain the difference in execution of triggers and stored procedures?

1017

how to create a new view in mysql? : Sql dba

927

What is the difference between jpql and sql?

1089

What is difference between hql and sql?

1070

How is a process of pl/sql compiled?

1150

What information is needed to connect sql*plus an oracle server?

1026

What is secondary key?

932

What are all the common sql functions?

1011