第一页, 前10项
select * from atb where id <((select min(id) from atb)+10)
最后1页,10项
select * from atb where id >((select max(id) from atb)-10)
标签:10,Sqlite,atb,08,第一页,id,select From: https://www.cnblogs.com/tulater/p/17468420.html
第一页, 前10项
select * from atb where id <((select min(id) from atb)+10)
最后1页,10项
select * from atb where id >((select max(id) from atb)-10)
标签:10,Sqlite,atb,08,第一页,id,select From: https://www.cnblogs.com/tulater/p/17468420.html