select ifnull(
(select max(distinct 成绩) from 成绩表
where 课程="语文" and
成绩<(select max(成绩) from 成绩表 where 课程="语文")),
null
) as 第二名成绩;

select ifnull(
(select max(distinct 成绩) from 成绩表
where 课程="语文" and
成绩<(select max(成绩) from 成绩表 where 课程="语文")),
null
) as 第二名成绩;