fetch second highest paid employee salary from each department

Asked Oct 15 '16 at 07:28

Active Nov 17 '22 at 23:02

Viewed 103 times

I want to fetch second highest paid employee salary from each department using SQL. Example, I've 100 departments with more than 500 employees in each department. & all these data is in one table.

Table Columns: EmpNo, EmpFirstName, EmpLastName, DepartmentNo, DepartmentName, Salary

Output: EmpNo, EmpFirstName, EmpLastName, DepartmentName, Salary

asked Oct 15 '16 at 07:28

B Talesra

1

What did you tried so far? – Renzo Oct 15 '16 at 07:31
1

Possible duplicate? http://stackoverflow.com/questions/8752458/how-select-second-line-from-top-2-or-something-similar and http://stackoverflow.com/questions/16568/how-to-select-the-nth-row-in-a-sql-database-table – lospejos Oct 15 '16 at 07:32
Sorry, Doesn't help... – B Talesra Oct 17 '16 at 11:10

fetch second highest paid employee salary from each department

0 Answers0