Query for second maximum salary in each in each department
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
how does a local variable is defined using t-sql? : Transact sql
What is sql server and ase?
What problem one might face while writing log information to a data-base table in pl/sql?
What are different types of functions in sql?
How many primary keys can a table have?
Difference between table function and pipelined function?
What are the types of operators available in sql?
Why commit is not used in triggers?
How can I get the number of records affected by a stored procedure?
What is a boolean in sql?
What is java sql package?
Explain the update statement in sql
Is sql a programming?
Explain the uses of a database trigger?
Explain 3 basic parts of a trigger.