mysql 去掉最高

SELECT MAX(score) AS max_score FROM scores;

DELETE FROM scores WHERE score = (SELECT MAX(score) FROM scores);

DELETE FROM scores WHERE score = (SELECT MAX(score) FROM scores);

CREATE TABLE scores (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    score INT
);

INSERT INTO scores (user_id, score) VALUES (1, 90);
INSERT INTO scores (user_id, score) VALUES (2, 85);
INSERT INTO scores (user_id, score) VALUES (3, 95);
INSERT INTO scores (user_id, score) VALUES (4, 88);

SELECT MAX(score) AS max_score FROM scores;

DELETE FROM scores WHERE score = (SELECT MAX(score) FROM scores);