• X
• XCoder
• XRegex
• Sample
• SQL查询
• 普通嵌套查询.txt

v9.8.2018.0605   由DataReader直接映射实体列表，以支持netstandard的MySql和SQLite，且提升性能

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