Count函数用于计算给定列的非空值,可以对查询返回的行进行计数。

示例


select count(*) from test;
select count(*) from test where c1 = 1;
select count(c1) from test where c1 = 1;