Convert SQL Rank to PySpark | Dataford Interview Questions

Convert SQL query(on the rank function to get second record)to pyspark

Asked in the technical interview stage. Use the provided employee records to return every record whose salary has the second distinct rank. The result should preserve ties at that rank.

Output

Return employee_id, employee_name, salary, and salary_rank.
Include only records with salary_rank = 2, ordered by employee_id ascending.
salary_rank must rank salaries from highest to lowest, with equal salaries sharing a rank.

Schema

employee_records

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee full name
salary	DECIMAL(12,2)	Employee annual salary
job_title	VARCHAR(100)	Employee job title

Your question is Convert SQL Rank to PySpark. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem