vf中怎么进行学生分数段的查询???
的有关信息介绍如下:我想你的分段应该是如下这样的:90分以下,90-99.9,100-100.9,110-119.9,120-129.9,130-139.9,140-150select 班级,cnt(*) 班级人数,sum(ii(语文成绩<90),1,00) rs0,;sum(iif(betw(语文成绩,90,99.9),1,00) rs90,;sum(iif(betw(语文成绩,100,109.9),1,00) rs100,;sum(iif(betw(语文成绩,110,119.9),1,00) rs110,;sum(iif(betw(语文成绩,120,129.9),1,00) rs120,;sum(iif(betw(语文成绩,130,139.9),1,00) rs130,;sum(iif(betw(语文成绩,140,149.9),1,00) rs140;group by 班级