Can I use… over() (empty over clause)

The over clause can be empty, meaning over all rows of the result.

SELECT *, COUNT(*) OVER()
  FROM …

Returns the original result with an additional column stating how many rows the result has.

Related

• Sub clauses:

  • over(partition by …)

  • over(order by …)

  • Framing:

    • over(… rows between …)

    • over(… range between …) (numeric), over(… range between …) (datetime)

    • over(… groups between …)

    • Frame exclusion:

      • over(… exclude no others)

      • over(… exclude current row)

      • over(… exclude group)

      • over(… exclude ties)

• Product specific: over(range between…) (strings, multi-columns)

Normative References

The over clause is defined in ISO/IEC 9075:2016-2 as part of optional feature T611, “Elementary OLAP operations”.