On 26 Aug 2010, at 3:39pm, Kirk Clemons wrote: > SELECT * FROM myTable WHERE _rowid_ = 100; SELECT * FROM myTable WHERE > _rowid_ = 101; SELECT * FROM myTable WHERE _rowid_ = 102;
SELECT * FROM myTable WHERE _rowid_ BETWEEN 100 AND 102 or SELECT * FROM myTable WHERE _rowid_ >= 100 AND _rowid_ <= 102 will give identical results. Technically speaking you might want to add 'ORDER BY _rowid_' to the end of those if the order matters. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users