SQL基础函数
1 count:统计数量
select count(pre_idType) as pid from lambda.cust_bank_info;
统计pre_idType的数量
2 avg:求平均值
select avg(id) from lambda.cust_bank_info
3 max:返回该列的最大值
select max(id) from lambda.cust_bank_account
4 min:返回该列的最小值
5sum:统计该列之和
select sum(id) from lambda.cust_bank_account
LIMIT限制
select * from lambda.loan_credit_detail LIMIT 5 offset 5;
select * from lambda.loan_credit_detail LIMIT 5,5;