Carlos Suarez <carlos.sua...@rolsoft.com> wrote: > Hello, my name is Carlos I need to replace de common sentence in > hsqldb --LIMIT min rows - max rows with something for delimit a query > in sqlite because this is not supported
select * from mytable limit 10 offset 5; -- or select * from mytable limit 5, 10; For more details, see http://sqlite.org/lang_select.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users