以下哪个 SQL 查询使用了窗口函数 ROW_NUMBER() 来为每个部门按工资降序排序并给出排名？ A. SELECT department_id, salary, DENSE_RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees; B. SELECT department_id, salary, ROW_NUMBER() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees; C. SELECT department_id, salary, RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees; D. SELECT department_id, salary, NTILE(4) OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees;