mysql 排序函数row

CREATE TABLE sales (
    id INT PRIMARY KEY,
    product_name VARCHAR(255),
    sale_date DATE,
    amount DECIMAL(10, 2)
);

SELECT 
    product_name,
    SUM(amount) AS total_amount,
    ROW_NUMBER() OVER (ORDER BY SUM(amount) DESC) AS rank
FROM 
    sales
GROUP BY 
    product_name
ORDER BY 
    rank;

SELECT 
    product_name,
    SUM(amount) AS total_amount,
    ROW_NUMBER() OVER (PARTITION BY product_name ORDER BY sale_date DESC) AS rank
FROM 
    sales
GROUP BY 
    product_name
ORDER BY 
    rank;

WITH ranked_sales AS (
    SELECT 
        product_name,
        SUM(amount) AS total_amount,
        ROW_NUMBER() OVER (ORDER BY SUM(amount) DESC) AS rank
    FROM 
        sales
    GROUP BY 
        product_name
)
SELECT 
    product_name,
    total_amount,
    ROW_NUMBER() OVER (ORDER BY rank) AS global_rank
FROM 
    ranked_sales
ORDER BY 
    global_rank;