Mysql statements.

Mysql statement .. If there are N data records, I want to take the last 10, for example, 1 ~ 100. get 91-100. how can I get it? If you use orderbyiddesclimit0 and 10, the value-is updated at all times, and you do not know the value of N. you cannot use the between method! ------ Solution -------------------- discuss ...... Use orderbyiddesclim mysql statements ..
If there are N data records, I want to take the last 10, for example, 1 ~ 100. get 91-100. how can I get it?
If order by id desc limit 100 is used, the value is-91.
N is updated at all times, and N is unknown. between is not used.
Method!

------ Solution --------------------
Discussion
......
If order by id desc limit 100 is used, the value is-91.
......