主题：关于2G大数据的后台统计问题

用分组统计就行，注意加粗的这一行，表示直接统计后台数据：

Dim g As New GroupTableBuilder("统计表1", DataTables("表A"))
g.Groups.AddDef("销售员")
g.Totals.AddDef("产品编号", AggregateEnum.Count)
g.FromServer = True
g.Build()
MainTable = Tables("统计表1")

难不倒foxtable:
 
 
Dim b As New GroupTableBuilder("统计表1","Select distinct 销售员编号,产品编号 From {表1}","11")
b.Groups.AddDef("销售员编号")
b.Totals.AddDef("产品编号", AggregateEnum.Count)
b.Build()
MainTable = Tables("统计表1")
 
知识点：
 
http://www.foxtable.com/help/topics/2307.htm

 
或者直接用SQL:

Select 销售员编号,Count(产品编号) From (Select distinct 销售员编号,产品编号 From {表1}) group by 销售员编号