Top-K Salaries Per Department

The table employees contains employee salaries and department assignments. The table query_parameters contains exactly one row with the requested value k.

For each department, rank its distinct salary levels from highest to lowest using dense ranks. Return every employee whose salary rank is at most k, including all employees tied at a qualifying salary.

Return department_id, employee_id, employee_name, salary, and salary_rank. Order rows by department_id ascending, then salary descending, then employee_id ascending. Do not use LIMIT.