如何在Postgres的另一列中为特定条件选择最近的日期？

SELECT condition_column, MAX(date_column) AS latest_date
FROM table_name
WHERE condition_column = '特定条件'
GROUP BY condition_column;

SELECT condition_column, MAX(date_column) AS latest_date
FROM table_name
WHERE condition_column IN ('特定条件1', '特定条件2', '特定条件3')
GROUP BY condition_column;

SELECT condition_column, date_column
FROM (
  SELECT condition_column, date_column,
         ROW_NUMBER() OVER (PARTITION BY condition_column ORDER BY date_column DESC) AS rn
  FROM table_name
  WHERE condition_column IN ('特定条件1', '特定条件2', '特定条件3')
) subquery
WHERE rn = 1;