select * from propro;
#查询成绩第二高
select max(id) from propro where id <(select max(id) from propro);
#查询成绩第二高的第二种方式
select * from (select * from propro order by id desc limit 2) as b order by id asc limit 1;
select * from propro;
#查询成绩第二高
select max(id) from propro where id <(select max(id) from propro);
#查询成绩第二高的第二种方式
select * from (select * from propro order by id desc limit 2) as b order by id asc limit 1;