MySql之优化查询语句

 一，减少重复查询   

SELECT t.province AS '省份',t.city as '城市',(select count(DISTINCT accountId) from try_apply_info where accountId = t.accountId) AS '人数'SELECT t.province AS '省份',t.cit