如何在Oracle SQL中更新多个重复行的单行

-- 步骤1：查询出重复行并确定目标行
SELECT employee_id, salary
FROM employees
WHERE salary IN (
  SELECT salary
  FROM employees
  GROUP BY salary
  HAVING COUNT(*) > 1
)
ORDER BY salary;

-- 步骤2：更新目标行
UPDATE employees
SET salary = (
  SELECT MAX(salary)
  FROM employees
  WHERE salary IN (
    SELECT salary
    FROM employees
    GROUP BY salary
    HAVING COUNT(*) > 1
  )
)
WHERE employee_id IN (
  SELECT employee_id
  FROM employees
  WHERE salary IN (
    SELECT salary
    FROM employees
    GROUP BY salary
    HAVING COUNT(*) > 1
  )
);

-- 步骤3：确认更新结果
SELECT employee_id, salary
FROM employees
WHERE salary IN (
  SELECT salary
  FROM employees
  GROUP BY salary
  HAVING COUNT(*) > 1
)
ORDER BY salary;