取消透视包含多列的SQL表

CREATE TABLE sales (
    id INT PRIMARY KEY,
    date DATE,
    product VARCHAR(50),
    region VARCHAR(50),
    sales_amount DECIMAL(10, 2)
);

CREATE TABLE pivoted_sales (
    date DATE,
    product VARCHAR(50),
    region VARCHAR(50),
    total_sales DECIMAL(10, 2)
);

SELECT 
    id,
    date,
    product,
    region,
    sales_amount
FROM 
    (SELECT 
         date,
         product,
         region,
         total_sales,
         ROW_NUMBER() OVER (PARTITION BY date, product, region ORDER BY date) AS rn
     FROM 
         pivoted_sales) AS temp
JOIN 
    sales s
ON 
    temp.date = s.date
    AND temp.product = s.product
    AND temp.region = s.region
    AND temp.rn = 1;