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

示例


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