统计个数count函数:
#统计表总行数:
select count(*) from user;
select count(id) from user;
#统计符合条件的行数:
select count(*) from user where id>2;
求和sum():
select sum(id) from user;
平均值avg():
select avg(id) from user;
最大值max():
select max(id) from user;
最小值min():
select min(id) from user;