iif函数用Case When语句代替的问题 Post By:2016/1/3 11:11:00 [只看该作者]
Dim b As New SQLGroupTableBuilder("统计表1","学生成绩") b.Groups.AddDef("科目") b.Totals.AddDef("分数",AggregateEnum.Max,"最高分") b.Totals.AddDef("分数",AggregateEnum.Min,"最低分") b.Totals.AddDef("分数",AggregateEnum.Average,"平均分") b.Totals.AddExp("分布_60以下","iif(分数 < 60,1,0)")
b.Totals.AddExp("分布_60-70","iif(分数 >= 60 And 分数 < 70,1,0)")