MySQL queries the penultimate record implementation method

2020-10-23 21:14:39
OfStack

Querying the penultimate record is sometimes used



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;