Dim b As new SQLGroupTableBuilder("统计","gk2015")
b.Groups.AddDef("bjxx","班级")
b.Totals.AddExp("专一人数","zf>=390 and zf<453 and mid(ksh,8,3)>'514' or zf>=445 and zf<480 and mid(ksh,8,3)<='514'")
b.Build
01
-11
02
-18
03
-13
04
-18
05
-16
06
-11
07
-20
08
-15
09
-11
10
-33
11
-27
12
-6
13
-7
14
-8
15
-28
16
-32
17
-21
18
-12
19
-22
20
-21
21
-18
22
-15
23
-18
24
-17
25
-1
26
-11
27
-9
28
-29
29
-15