网页编程网

有时候会用到查询倒数第二条记录。

select   *     
 from   tablename   a     
 where (  
  select   count(*)     
  from   tablename   b     
  where   a.id<b.id)=1  
//方法二
select   *     
 from   tb1     
 order   by   tb1.id   desc     
 limit   1,1;