mysql先排序 在分组

SELECT column1, column2, ...
FROM (
    SELECT column1, column2, ...
    FROM table_name
    ORDER BY sort_column
) AS subquery
GROUP BY group_column;

SELECT column1, column2, ...
FROM (
    SELECT column1, column2, ...,
           ROW_NUMBER() OVER (ORDER BY sort_column) AS row_num
    FROM table_name
) AS subquery
GROUP BY group_column;

SELECT customer_id, SUM(amount) AS total_amount
FROM (
    SELECT customer_id, amount
    FROM orders
    ORDER BY order_date
) AS subquery
GROUP BY customer_id;

SELECT customer_id, SUM(amount) AS total_amount
FROM (
    SELECT customer_id, amount,
           ROW_NUMBER() OVER (ORDER BY order_date) AS row_num
    FROM orders
) AS subquery
GROUP BY customer_id;