4 ms·
The article highlights the Oracle flavor of this functionality, but similar windowing operations are available in PostgreSQL[1] and SQL Server[2]. Edit to add
by samch 10y ago
The article highlights the Oracle flavor of this functionality, but similar windowing operations are available in PostgreSQL[1] and SQL Server[2]. Edit to add that I have no idea if JOOQ supports windowing functions in non-Oracle systems.
1: https://www.postgresql.org/docs/current/static/functions-window.html https://www.postgresql.org/docs/current/static/functions-win...
2: https://msdn.microsoft.com/en-us/library/ms189461.aspx https://msdn.microsoft.com/en-us/library/ms189461.aspx
- wmfiv 10y agoIf you're a SQL fan and using the JVM, JOOQ is pretty much the best thing since sliced bread. It has excellent cross database window support. http://www.jooq.org/doc/3.8/manual/sql-building/sql-statements/select-statement/window-clause/ http://www.jooq.org/doc/3.8/manual/sql-building/sql-statemen...
- lukaseder 10y agoLogical windowing is not available in those other databases, i.e. only Oracle can specify a window whose size depends on the content of the current row, rather than a fixed number of rows.
- samch 10y agoI'm not sure that's entirely correct. This is from the SQL Server MSDN docs, "Alternatively, the RANGE clause logically limits the rows within a partition by specifying a range of values with respect to the value in the current row." Source: https://msdn.microsoft.com/en-us/library/ms189461.aspx https://msdn.microsoft.com/en-us/library/ms189461.aspx