sql优化-count(distinct)改写

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

posted @ 2021-06-10 18:55  月图灵  阅读(418)  评论(0编辑  收藏  举报