- SQL code
select top(1) stu_score from (select top(2) stu_score from tb_score where course_id= (select course_id from tb_course where course_name = 'java') order by stu_score Desc ) order by stu_score ASC
------解决方案--------------------
- SQL code
select top(1) stu_score from (select top(2) stu_score from tb_score where course_id= (select course_id from tb_course where course_name = 'java') order by stu_score Desc --这样选出来的是倒数第二句的成绩) order by stu_score ASC--#1.select top(1) stu_score from(select top(2) stu_score from tb_score where course_id=(select course_id from tb_course where course_name = 'java') order by stu_score asc) Torder by stu_score desc --#2.select * from( select rowno = row_number() over(order by a.stu_score), * from tb_score a inner join tb_course b on a.course_id = b.course_id where b.course_name = 'java') Twhere rowno = 2