Versions Compared

Old Version 14

changes.mady.by.user Lefty Leverenz

Saved on

compared with

New Version 15

changes.mady.by.user Lefty Leverenz

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: indentation kludge

...

Distinct is supported for aggregation functions including SUM, COUNT and AVG, which aggregate over the distinct values within each partition. Current implementation has the limitation that no ORDER BY or window specification can be supported in the partitioning clause for performance reason. The supported syntax is as follows.

No Format
      COUNT(DISTINCT a) OVER (PARTITION BY c)

...