sql优化-count(distinct)改写
Select count(distinct c_ajbh) from t_aj
改写后:
Select count(*) from (select distinct c_ajbh from t_aj where ...)t2
Select count(distinct c_ajbh) from t_aj
改写后:
Select count(*) from (select distinct c_ajbh from t_aj where ...)t2
