select * from emp x where 2=(select count(distinct sal) from emp y where x

Query for second maximum salary in each in each department

Question Posted / suneelkumar

15 Answers
38320 Views
DST Global Solutions, TCS, I also Faced
E-Mail Answers

Answer Posted / suneelkumar

select * from emp x where 2=(select count(distinct sal) from
emp y where x.sal<=y.sal) group by deptno;

Is This Answer Correct ?

0 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the use of sql trace?

952

What is the difference among union, minus and intersect?

1001

What is sql*loader and what is it used for? : aql loader

1174

What are procedures used for?

985

Why is sql important?

1109

Can we commit inside a trigger?

994

What are synonyms in sql?

973

what is timestamp in mysql? : Sql dba

1078

Enlist the characteristics of pl/sql?

1803

How do I run a sql query?

1023

What is a natural join sql?

977

Is it important to partition hard disk?

1024

what are rollup and cube in t-sql? : Transact sql

1100

What are different methods to trace the pl/sql code?

1120

Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me

2024