Calculate running total and 2nd highest salary for each department in SQL.

• Use window functions like ROW_NUMBER() and SUM() to calculate running total.

• Use a subquery to find the 2nd highest salary for ...read more