Simon Riggs <[EMAIL PROTECTED]> writes:
> The SQL window functions seem to require an ordering for most of their
> operations.
AFAICS, the entire concept of a "window" implies the input is ordered
in some way; what operations would they provide that don't require this?
> It is possible that that
An example of a window function is RANK or a moving AVG, though also
include ROW_NUMBER or CUME_DIST. They are a different kind of aggregate
introduced by/included in SQL:2003, which require a "sliding window" of
rows.
The SQL window functions seem to require an ordering for most of their
operatio