Query for second maximum salary in each in each department
- 15 Answers
- 34258 Views
- DST Global Solutions, TCS, I also Faced
- E-Mail Answers
Answer Posted / ram
SELECT empno,salary,dept_id FROM (SELECT empno,salary,dept_id,DENSE_RANK() OVER (PARTITION BY Dept_id ORDER BY Salary DESC)
as Rnk FROM emp) WHERE Rnk = 2;
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Write the command to remove all players named sachin from the players table.
Is merge a dml statement?
What is foreign key sql?
How can you save or place your msg in a table?
Can a trigger call a stored procedure?
Which are the different case manipulation functions in sql?
What is database migration?
explain about mysql and its features. : Sql dba
Does a primary key have to be a number?
How do I run a program in pl sql?
I need a function for a train ticket reservation please answer it thanks in advance
What is the starting oracle error number?
Can you join views in sql?
what are the authentication modes in sql server? How can it be changed? : Sql dba
What does desc stand for?
