On Jan 12, 9:54 am, Lukas Eder <[email protected]> wrote: > For the reference, I have encountered true window function support in any > of these databases: > > - DB2 > - Postgres > - Oracle > - SQL Server > - Sybase SQL Anywhere > > Oracle has by far the most functionality in this field. SQL Server is > rather limited. I like your rank simulation though. I have never thought of > this like that before. I might give this some thought and build in some > window function simulation into jOOQ to increase compatibility between > databases.
Teradata also supports them and Firebird will in the next release. SQL Server will have much better support with Denali (lag(), lead() "rows between ...") Actually PostgreSQL is a bit more advanced than Oracle as it has everything that Oracle has (except some statistical aggregates) but also has re-usable WINDOW definitions and I think the ROWS BETWEEN part in Oracle is not as complete as with Postgres 9.1 -- You received this message because you are subscribed to the Google Groups "H2 Database" group. 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.
