表結(jié)構(gòu)CREATE TABLE grade(num INT(10) NOT NULL,course VARCHAR(10) NOT NULL,score FLOAT);表數(shù)據(jù)INSERT INTO grade VALUES(1001, '數(shù)學(xué)', 80), (1001, '語(yǔ)文', 90), (1001, '英語(yǔ)', 90), (1001, '計(jì)算機(jī)', 95);INSERT INTO grade VALUES(1002, '數(shù)學(xué)', 88), (1002, '語(yǔ)文', 90), (1002, '英語(yǔ)', 89), (1002, '計(jì)算機(jī)', 90);INSERT INTO grade VALUES(1003, '數(shù)學(xué)', 80), (1003, '語(yǔ)文', 98), (1003, '英語(yǔ)', 85), (1003, '計(jì)算機(jī)', 95);查詢語(yǔ)句SELECT course, MAX(score), any_value(num) FROM grade GROUP BY course;查出來(lái)的數(shù)據(jù)不對(duì)，后面是1001，跟成績(jī)對(duì)應(yīng)不上course MAX(score) any_value(num)數(shù)學(xué) 88 1001語(yǔ)文 98 1001英語(yǔ) 90 1001計(jì)算機(jī) 95 1001求解決