v9.6.2017.0808 重构正向工程,基于映射表查找数据库字段类型到实体类型的映射
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