如何在 SQL Server 中比较具有相同 ID 的不同行中的相同值

您可以为此使用窗口函数：

SELECT 
  id, 
  name,
  CONCAT(
    age, 
    CASE WHEN MAX(pog) OVER(PARTITION BY id) = 'Benchmark' THEN
      CASE WHEN COALESCE(pog, '') <> 'Benchmark' AND Age = MAX(CASE WHEN pog = 'Benchmark' THEN Age END) OVER(PARTITION BY id) THEN '-Yes' ELSE '-No' END 
    END
  ) as age,
  pog
FROM table

我相信这也会起作用：

SELECT 
  id, 
  name,
  CONCAT(
    age, 
    CASE COALESCE(MAX(CASE WHEN pog = 'Benchmark' THEN age END) OVER(PARTITION BY id), -1)
      WHEN age THEN REPLACE(CONCAT(age, pog, '-Yes'), 'Benchmark-Yes', '')
      WHEN -1 THEN ''
      ELSE '-No' END 
    END
  ) as age,
  pog
FROM table