34,588
社区成员
发帖
与我相关
我的任务
分享
SELECT CONVERT(varchar(8),DATEADD(SS,DATEDIFF(SS,'2009-06-04 14:24:53','2009-06-04 14:26:22'),0),108)
--------
00:01:29
(所影响的行数为 1 行)
SELECT xh as 序号,
SUM(CASE WHEN fs>=60 THEN 1 ELSE 0 END) as 及格数,
SUM(CASE WHEN fs<60 THEN 1 ELSE 0 END)as 不及格数
from t
group by xh
SELECT xh,
SUM(CASE WHEN fs>=60 THEN 1 ELSE 0 END) as 及格数,
SUM(CASE WHEN fs<60 THEN 1 ELSE 0 END)as 不及格数
from t group by xh
SELECT xh,
SUM(CASE WHEN fs>=60 THEN 1 ELSE 0 END)[及格数],
SUM(CASE WHEN fs<60 THEN 1 ELSE 0 END)[不及格数]
FROM T GROUP BY XH
SELECT xh,
SUM(CASE WHEN fs >=60 THEN 1 ELSE 0 END),
SUM(CASE WHEN fs <60 THEN 1 ELSE 0 END)
FROM t
GROUP BY xh