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.