Question

SQLite 如何查询最后一条数据？

如同SQL的select top 1 * from users order by uid desc
不过SQLite 没有这top 方法。有什么其他方法能做到吗？

Answer 1

select * from users LIMIT 5 order by uid desc ;