这两个分都满足的zf_y>=325分，km6>=285分的各班学生

SELECT szbj as 班级,kldm as 科类代码,IIF(kldm='1',coun(zf>=529),IIF(kldm='5',coun(zf>=509),coun(zf>=325))) as 人数 FROM cj022902 GROUP BY szbj,kldm ORDER BY szbj,kldm

SELECT szbj,SUM(IIF(zf_y>=325 and km6>=285,1,0)) rs,"12130229140" lb FROM cj022902 WHERE SUBSTR(ksh,9,3)="140" GROUP BY szbj

[ 本帖最后由 tlliqi 于 2013-3-1 11:39 编辑 ]