Query for second maximum salary in each in each department
- 15 Answers
- 34362 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
How run sql*plus commands that are stored in a local file?
Which is better varchar or nvarchar?
How to start oracle sql developer?
Is sql harder than python?
how to do backup entire database? : Transact sql
What is the difference between row level and statement level trigger?
Why do we need cursors in pl sql?
Is it possible for a table to have more than one foreign key?
Explain the rollback statement?
Why do we use set serveroutput on?
Can we insert data into view?
What is mutating error?
Can we perform dml on view?
What is an escape character in sql?
What is insert command in sql?
