Use SQL query with window function to find second highest salary by department

• Use ROW_NUMBER() function to assign a unique rank to each salary within a department

• Filter the results to only include row...read more