为什么distinct后还是有重复项

Question

select
DISTINCT
left(ProductClassName,LOCATE(">>",ProductClassName)-1) 一级品类,
sum(ProductNum+ProdutNumUpdate) 销量
from
lm_sh_order_settle_excel_aliexpress
where
SettlementDate between "2021-06-01" and "2021-06-30"
and
sku in(2538628,2565482,2165489,2025274,2051544,1814839,2204759,1853641,
1860895,2210660,2180455,2526731)
group by sku,ProductClassName

Answer 1

没有大神解答咩