Hello, I've noticed that the H2 SELECT statement supports a TOP clause, which is equivalent to using the H2 / HSQLDB / MySQL / Postgres / SQLite LIMIT clause. While Sybase ASE and SQL Server only know the TOP clause (without any offsets), Sybase SQL Anywhere also knows an optional TOP .. START AT .. clause, similar to LIMIT .. OFFSET ..
Some details can be seen on this Sybase blog: http://iablog.sybase.com/paulley/2009/04/select-top-and-start-at/ Maybe this would be interesting for H2 to support as well? 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/-/wwOiFSbxrQMJ. 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.
