COUNT_IF(Lakehouse v2)
式がTRUEになる行数を返します。
Analyzeの構文
Section titled “Analyzeの構文”func.count_if(get_column(table, 'salary') > 80000)Analyzeの例
Section titled “Analyzeの例”func.count_if(get_column(table, 'salary') > 80000)
┌────┐│ 42 │└────┘SQLの構文
Section titled “SQLの構文”COUNT_IF(<salary> > 80000)SELECT COUNT_IF(salary > 80000) FROM employees;
┌────┐│ 42 │└────┘