面试题碰到的,做出来看一下
SELECT MAX(SCORE) AS second,class FROM sl_student WHERE SCORE NOT IN
(SELECT MAX(SCORE) FROM sl_student group by class)GROUP BY class
面试题碰到的,做出来看一下
SELECT MAX(SCORE) AS second,class FROM sl_student WHERE SCORE NOT IN
(SELECT MAX(SCORE) FROM sl_student group by class)