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 | 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 j How do i do it? -- View this message in context: http://old.nabble.com/how-to-return-these-data-from-the-DB-tp32396248p32396248.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
