Hi Thomas,
You're probably right about the low priority. Seeing that Sybase (SQL
Anywhere) thinks about adding support for the MySQL / Postgres LIMIT ..
OFFSET clause anyway... and I have just now checked what SQL Server 2012 is
going to be up to. Apparently, they're moving away all together from the
TOP clause and implement something entirely different:
OFFSET 10 ROWS
FETCH { FIRST | NEXT } 10 ROWS ONLY
http://msdn.microsoft.com/en-us/library/ms188385(v=sql.110).aspx
That will then precisely match DB2, Derby and Ingres syntax. Compatibility
with that clause seems to be covered, already:
http://h2database.com/html/features.html?highlight=compatibility&search=compatibility#compatibility
Cheers
Lukas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/h2-database/-/l1TKFrjesUYJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
