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 …),over(… exclude …).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.
