单选题— 以下哪个 SQL 查询使用了窗口函数 ROW_NUMBER() 来为每个部门按工资降序排序并给出排名？B A、SELECT department_id, salary, NTILE(4) 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, DENSE_RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees;