Teradata -从表中获取第二个最新日期，并引用它

WITH ranked_dates AS (
  SELECT
    your_date_column,
    ROW_NUMBER() OVER (ORDER BY your_date_column DESC) AS date_rank
  FROM
    your_table_name
)
SELECT
  your_date_column AS second_latest_date
FROM
  ranked_dates
WHERE
  date_rank = 2;