Leetcode Problem 2668. Find Latest Salaries

SQL Algorithm

1. Select all columns from the Salary table.
2. Use the GROUP BY clause to group the results by emp_id.
3. Apply the MAX function to the salary column to find the highest salary for each emp_id.
4. Include the firstname, lastname, and department_id columns in the GROUP BY clause to ensure they are included in the final result.
5. Order the final result by emp_id in ascending order.

Pandas Algorithm

1. Sort the DataFrame by the salary column in descending order.
2. Drop duplicate rows based on the emp_id column, keeping the first occurrence.
3. Sort the resulting DataFrame by emp_id in ascending order.
4. Return the final DataFrame.