Question

mysql如何取得筛选出的10条数据的最大id-CSDN论坛

Answer 1

select max(id) from tablename limit 10;

Answer 2

order by id desc

limit 0,10

Answer 3

select MAX(ID) from xxxx