Rick Ratchford wrote: > Perhaps to solve the larger problem I have in a different post, I > have a question on retrieving records. > > How do you request a fixed number of records starting from a location > in the data based searched for, all in one SQL statement? > > "SELECT Date = '2009-01-01' ...plus the next x number of records"
select * from myTable where Date >= '2009-01-01' order by Date limit :x; Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
