Top Filter for SQLite

SELECT [Collectdatetime] as ' time ', [channel_34] as ' channel ', [channel_54] as ' channel ' from [DataTable]
where [Collectdatetime] < ' 2014-11-20 17:15:34 ' and [collectdatetime]> ' 2014-11-19 17:15:34 '
LIMIT 10,20

Limit A, b

Where a represents the index, which is the data from which it is filtered, and where it begins to read

b represents the number of bars, starting from a position, the number of reading data

Suppose select [Collectdatetime] as ' time ', [channel_34] as ' channel ', [channel_54] as ' channel ' from [DataTable]
where [Collectdatetime] < ' 2014-11-20 17:15:34 ' and [collectdatetime]> ' 2014-11-19 17:15:34 '

100 Statements were filtered out

Then the last limit 10,20, from the result, 100 statements, the 10th data start, the backward filter 20 data

In other words, the last data obtained is from 10th to 30th.

Top Filter for SQLite