SQL3 id自增主键不连续时，查询数据库指定行的命令

参考https://www.cnblogs.com/bluedy1229/p/8992965.html

查询倒数第6~10个数据 命令

select * from table_name where id not in(select id from table_nameOrder by id desc limit 5 ) Order by id desc limit 5;

 

查询第6~10个数据行：

select * from table_name where id not in(select id from table_name  Order by id asc limit 5 ) Order by id asc limit 5;

 

方法2：

select * from dryChemistryTestRecord Order by testTime desc limit 5 OFFSET 2;