查询

[njlyzh]

在一张表中，有一个字段是成绩，求及格率,及格线>=60

[快溜]

[bill024]

select sum(case when score>=60 then 1 else 0 end) * 1.0 /count(*) from t

[AcHerat]

select cno as [课程号],ltrim(sum(case when score >= 60 then 1 else 0 end)*100./count(distinct sno)) + '%' as [及格率]
from tb
group by cno

[zshsuming]

select sum(case when 分数>=60 then 1 else 0 end) * 1.0/count(*) from t

[Shawn]

SELECT 班级, cast(1.*SUM(case when score>=60 then 1 ELSE 0 END)/COUNT(1) AS VARCHAR(10))+'%'
FROM t
GROUP BY 班级

[njlywy]

select ltrim(sum(case when score >= 60 then 1 else 0 end)*100/count(*)) + '%' from tablename

[--小F--]

select ltrim(sum(case when score >= 60 then 1 else 0 end)*100.0/count(*)) + '%' from tb

[mabailin]

[Quote=引用 7 楼 fredrickhu 的回复:]

SQL code
select ltrim(sum(case when score >= 60 then 1 else 0 end)*100.0/count(*)) + '%' from tb
[/Quote]
+