数据库sql查询成绩第二高

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;