4 ms·

tl;dr Oracle.

• deleted 10y ago
  [deleted]
• 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 ago
    If 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 ago
    Logical 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 ago
      I'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
• btilly 10y ago
  No, it is in the SQL standard. Best supported in Oracle because that is where it came from.
• dx034 10y ago
  SQL Server can do something similar, although they introduced it later (think SQL Server 2012).