临海营销型网站建设互联网营销师考证多少钱

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;