优化ETL过滤模块
Select Top 5 CategoryID, Count(*) as ProductCount From (Select * From Product Where IsEnable=1) as XCode_Temp_1 Where IsDelete=0 Group By CategoryID Having Count(*)>10 Order By Count(*) Desc