Interested to Buy Any Domain ? << Click Here >> for more details...
Query for second maximum salary in each in each department
- 15 Answers
- 38262 Views
- DST Global Solutions, TCS, I also Faced
- E-Mail Answers
Answer Posted / jairam
select deptno,Max(e1.sal) from emp e1
where e1.sal NOT IN(select Max(e2.sal) from emp e2
group by e2.deptno)group by e1.deptno
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
what is a control file ? : Sql dba
What is Histogram?
what is csv? : Sql dba
What is the difference between syntax error and runtime error?
What is the difference between the sql*loader and import utilities? : aql loader
What is procedure and function?
What are the parts of a basic sql query?
what is rollback? : Sql dba
How many postgresql users are there, worldwide?
what are date and time functions in mysql? : Sql dba
Is postgresql a nosql database?
who introduced sql?
What is procedure explain with example?
What is the difference between null value, zero, and blank space?
What found sql?
