-- 排名倒数第二 select t2.* from ( select t1., row_number() over(ORDER BY t1.sc asc) pm1 from ( select ,TIMESTAMPDIFF(MINUTE,start_time,submit_time) as sc from exam_record WHERE submit_time is not NULL ) as t1 ) t2 WHERE t2.pm1=2 JOIN -- 第二名 select t4. from ( select t3., row_number() over(ORDER BY t3.sc d...
