3 ms·
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
by 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 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