COUNT (Lakehouse v2)
Returns the number of rows or non-NULL values.
Analyze Syntax
Section titled “Analyze Syntax”func.count()Analyze Examples
Section titled “Analyze Examples”func.count()SQL Syntax
Section titled “SQL Syntax”COUNT()SQL Examples
Section titled “SQL Examples”SELECT COUNT(*) FROM employees;
┌──────────┐│ count(*) │├──────────┤│ 1000 │└──────────┘
SELECT COUNT(DISTINCT department) FROM employees;
┌──────────────────────────────┐│ count(distinct department) │├──────────────────────────────┤│ 5 │└──────────────────────────────┘