或者先用排除法,用简单的进行测试,看看能否通过,如果能通过,可能C值有问题。
Dim b As New SQLGroupTableBuilder("占比统计表1","person")
b.Groups.AddDef(zd(TongJi) , TongJi)b.Totals.AddExp("人数_60以下"," Case When age < 60 Then 1 Else 0 End ")b.Totals.AddExp("人数_90以上"," Case When age >= 90 Then 1 Else 0 End ")t = b.build()