Re: [sqlite] how to return these data from the DB

LiranR wrote: > For > example: > Time |data > --- > 5 |x > 7 |y > 9 |z > 11 | i > 13 | j > 15 | k > > Now, when i want from time 8 (8 is not in the table) to time 13 i will get : > > 9 z > 11 i > 13

[sqlite] how to return these data from the DB

Hi all! I have a table which has an index column ( its name is 'Time' ). I want to be able to return number of rows - the rows are from a given time to a second given time. The thing is that the given time could also not be in the table. For example: Time |data --- 5 |