in Mysql, I am trying to get the oldest record of the last 10 records.
To get the last 10 I would simply do
SELECT * FROM table ORDER BY id DESC LIMIT 10;
to get the oldest I simply use the ASC order.
I need to first order in DESC order to get the last 10 and then order by ASC to get the first record of that array.
which query would I use to get row number 10 in DESC order, namely, the oldest of the 10 newest?
解决方案SELECT * FROM table
ORDER BY id
DESC LIMIT 9, 1
Here, OFFSET is 9 --> that means 10th row (which will be first row in the last 10 rows when ordered back in Ascending order).