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.