My error. I was replying to the wrong email. Shane Harrelson wrote: > 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 >
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
