Additionally, it's important to note that the LIMIT/OFFSET clause is not standard SQL, and although it is supported by SQLite, and many other SQL engines, there are some that do NOT support it, most notably Microsoft SQL Server.
HTH. -Shane On Tue, May 19, 2009 at 2:23 PM, Sam Carleton <scarle...@gmail.com> wrote: > Kees Nuyt wrote: > >> Imagine a SELECT with an ORDER BY which makes SQLite sort >> the resultset before it can return the first row in the >> resultset. Need I say more? >> >> http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor >> >> > Thank you for the link, it is a VERY useful read, VERY useful! > > Sam > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users