如何在SQL查询中获取父值和上次替换的值

SELECT 
    ROW_NUMBER() OVER (ORDER BY column_name) AS row_num,
    column_name
FROM 
    table_name

SELECT 
    t1.column_name AS current_value,
    t2.column_name AS parent_value,
    t2.replaced_value AS last_replaced_value
FROM 
    (SELECT 
        ROW_NUMBER() OVER (ORDER BY column_name) AS row_num,
        column_name
    FROM 
        table_name) t1
LEFT JOIN 
    (SELECT 
        ROW_NUMBER() OVER (ORDER BY column_name) - 1 AS row_num,
        column_name AS replaced_value
    FROM 
        table_name) t2
ON 
    t1.row_num = t2.row_num