mysql 分组输出所有信息

-- 创建示例表
CREATE TABLE sales (
    id INT AUTO_INCREMENT PRIMARY KEY,
    product_category VARCHAR(50),
    amount DECIMAL(10, 2)
);

-- 插入示例数据
INSERT INTO sales (product_category, amount) VALUES
('Electronics', 1000),
('Clothing', 500),
('Electronics', 1500),
('Clothing', 700),
('Books', 300);

-- 使用GROUP BY进行分组并计算总销售额
SELECT product_category, SUM(amount) AS total_sales
FROM sales
GROUP BY product_category;

SELECT product_category, MAX(amount) AS max_amount, MIN(amount) AS min_amount
FROM sales
GROUP BY product_category;

-- 确保amount列的数据类型一致
ALTER TABLE sales MODIFY amount DECIMAL(10, 2);

-- 创建索引以优化查询
CREATE INDEX idx_product_category ON sales(product_category);

-- 分页查询
SELECT product_category, SUM(amount) AS total_sales
FROM sales
GROUP BY product_category
LIMIT 10 OFFSET 0;