LiranR <liran.rit...@gmail.com> 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 j > > How do i do it?
select * from MyTable where Time between 8 and 13; -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users