Sqllite (Websql) How to sort and page queries (Sqllite syntax)

SELECT * from Table ORDER by ID DESC Limit 10,9

Limit semantics: Skip 10 lines and take 9 rows

Reference:

SQLite limit Usage If I'm going to 11-20 of the Account table data Select * From account Limit 9 Offset 10; The above statement means getting data from the account table, skipping 10 rows, taking 9 rows well, I think this feature is enough for many web medium-sized websites to use this. You can also write a select * from the account limit10,9 with the same effect as above. General public beta: sql = "SELECT * from Flycrocodile where" + conditions + "ORDER BY" + sort + "limit" + how many records to display + "offset" + how many records to skip; for example, select * from F Lycrocodile limit offset 20 means: Skip 20 records from the Flycrocodile table and select 15 Records. This article turns from: Http://blog.csdn.net/xiaoguang44/article/deta ils/8211676

Sqllite (Websql) How to sort and page queries (Sqllite syntax)