文章目录 1 结论2 示例 1 结论 计数 count count(1)、count(*):所有列(包含空列) count(列):所有非空列 count(distinct 列):去重非空列 2 示例 with t_test as ( select 1 id, null name from dual union all select 2 id, 'a' name from dual union all select 3 id, 'a' name from dual ) select count(1), -- 3 count(*), -- 3 count(name), -- 2 count(distinct name) -- 1 from t_test;