SQLite数据查询最后10条记录语句

[曹石]

select * from (select * from 表 order by 字段 DESC limit 10) order by time DESC;