«

MySQL查询倒数第二条记录实现方法

时间:2024-3-1 22:54     作者:韩俊     分类: Mysql


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

last=HolderChangeHistory.find_by_sql

(["               SELECT * FROM holder_change_histories 

                  where treasure_id = ? 

                  order by id desc   

                  limit   1,1  ",

                  @hch.treasure_id])

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;

标签: mysql

热门推荐