We're not talking about transaction control - we're talking about limiting the size of the result set. And LIMIT/OFFSET clauses are not supported by the SQL-92 standard. LIMIT is listed as a reserved word, but that's it.
http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt On Wed, May 20, 2009 at 2:47 PM, John Stanton <jo...@viacognis.com> wrote: > What makes you think that transaction control is not part of SQL-92? > > If a database engine does not support transaction control it is not a > full implementation. Transaction control is at the very heart of > effective data management. > > Shane Harrelson wrote: > > 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 > > > > _______________________________________________ > 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
