GROUP BY 和 distinct

SELECT distinct service_ip,service_name FROM t_srv_perf_analyze

SELECT service_ip,service_name ,count(*) FROM t_srv_perf_analyze
GROUP BY service_ip,service_name

SELECT service_name,service_ip,DATE_FORMAT(access_time,'%Y-%m-%d') as 'access_time',COUNT(*) FROM t_srv_perf_analyze GROUP BY service_ip,service_name,DATE_FORMAT(access_time,'%Y-%m-%d')