编辑代码

CREATE DATABASE test;
use test;

CREATE TABLE F0915(
    YEAR VARCHAR(10),
    MONTH VARCHAR(10),
    AMOUNT DECIMAL(18,1)
);

INSERT INTO F0915 VALUES
('2020','1',9.1),
('2020','2',9.2),
('2020','3',9.3),
('2020','4',9.4),
('2021','1',8.1),
('2021','2',8.2),
('2021','3',8.3),
('2021','4',8.4);

SELECT * FROM F0915;

SELECT
    YEAR,
    MAX(CASE WHEN MONTH = 1 THEN AMOUNT ELSE NULL END) M1,
    MAX(CASE WHEN MONTH = 2 THEN AMOUNT ELSE NULL END) M2,
    MAX(CASE WHEN MONTH = 3 THEN AMOUNT ELSE NULL END) M3,
    MAX(CASE WHEN MONTH = 4 THEN AMOUNT ELSE NULL END) M4
FROM F0915
GROUP BY YEAR;