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

The select into statement is most often used to create backup copies of tables or for archiving records?

1068

Can you rollback after commit?

993

what are integrity rules?

1035

What is the difference between drop and truncate commands?

1062

What are commit, rollback, and savepoint?

999

What are joins in sql?

1048

What is where clause in sql?

1043

Which one is better subquery or joins?

1065

What is the difference between microsoft sql and mysql?

967

can a stored procedure call itself or recursive stored procedure? : Sql dba

1033

What is the usage of sql functions?

1147

What is oracle sql called?

925

What is cross join example?

1012

How do you declare a constant?

962

Is sql a oracle?

982