Understanding of limit and offset in sqlite3 Database

Reposted from: danshiming blog; http://blog.163.com/danshiming@126/blog/static/109412748200921163550296/

Select * From trom_daTa where device_id = 12 order by time_stamp DESC limit 1 offset 0

In an SQL statement, limit 1 offset 0 indicates that one record is obtained based on 0th records (including 0th records) in the query results, the obtained records are 0th records, that is, the maximum time for device_id = 12 and time_stamp in this table.

 

Limit: number of records to be retrieved (reference point) offset reference point

 

Select * From trom_daTa limit nnumrecord offset nbaserow

Indicates that the nbaserow row (index based on 0) (including the row) is used to retrieve the nnumrecord after the row.