How to implement the last-to-last record query in MySQL _ MySQL-mysql tutorial

This article mainly introduces the implementation method of the second-to-last record query in MySQL. This article provides code examples. the important part has been highlighted. if you need a friend, you can refer to it and sometimes use the second-to-last record query.

The code is as follows:

Last = HolderChangeHistory. find_by_ SQL
(["SELECT * FROM holder_change_histories
Where treasure_id =?
Order by id desc
Limit 1, 1 ",
@ Hch. treasure_id])

The code is as follows:

Select *
From tablename
The code is as follows:

Select *
From tb1
Order by tb1.id desc
Limit 1, 1;