Given an Employee table with columns Employee name, Salary, and Department, write a PySpark query to find the name of the employee with the second highest salary in each department.

Find the 2nd highest salary employee in each department using PySpark.

• Read the CSV file into a DataFrame using spark.read.csv().

• Group the DataFrame by 'Department' and use the 'dense_rank()' function ...read more