I just learned today that Interbase 7.5 does not support it either.
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 <[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
