COUNT

COUNT

Count the number of non-null elements in the column/group/window. Supported on all types. If used with the syntax COUNT(*) returns the total number of rows instead of non-null rows.

Note

When used as a window function with an ORDER BY clause but no window frame, ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW is used by default.