像我图片上那样,如果我要按照schoolname分别计算pr1,请问那该怎么弄?[/quote]
能把语句直接贴出来不,这个图没办法帮你修改。。。[/quote]
语句就在上面图片那段加蓝的就是
select cast( (select COUNT(*) from Schools join Applications on Applications.Sch_id=Schools.Schoolid
where Type='本科' and score1<2300 and Score2<111 and Schoolname=Schoolname group by Schoolname)/
((select COUNT(*) from Schools join Applications on Applications.Sch_id=Schools.Schoolid
where Type='本科' and Schoolname=Schoolname GROUP by Schoolname)+0.0*100)*100 As Dec(4,2)) as pre1,Schoolname from Schools
join Applications on Applications.Sch_id=Schools.Schoolid
group by schoolname