MySQL中如何计算同比和环比_Mysql_脚本之家 (jb51.net)

直接按这个教程来吧。里面你看环比的

环比的语句

CREATE TABLE sales_data (

    month VARCHAR(10),

    sales_amount DECIMAL(10, 2)

);

INSERT INTO sales_data (month, sales_amount) VALUES

('2023-01', 10000),

('2023-02', 12000),

('2023-03', 13000);

-----------------------------

SELECT

    t1.month AS current_month,

    t2.month AS previous_month,

    (t1.sales_amount - t2.sales_amount) / t2.sales_amount * 100 AS month_on_month_growth_rate

FROM

    sales_data t1

JOIN

    sales_data t2 ON t1.month = DATE_ADD(t2.month, INTERVAL 1 MONTH)

ORDER BY

    t1.month;