MySQL的sql用法示例

#统计客户数量

use customer;
SELECT count(*) FROM t_customer where CREATED_TIME>"2021-5-31 10:30:00" and c_a=1;

#统计去重后的客户数量，去重字段根据编码去重
use customer;
SELECT count(DISTINCT c_code) AS count FROM t_customer where CREATED_TIME>"2021-5-31 10:30:00" and c_a=1;

#统计去重后的客户数量，去重字段根据编码去重
SELECT count(t.counts) FROM ( SELECT c_code,count(*) AS counts fromt_customer GROUP BY c_code ) AS t;