27,579
社区成员
发帖
与我相关
我的任务
分享
select count(case when tid = 10 then 1 end) / count(case when tid = 0 and ok = 1 then 1 end)
from t
SELECT COUNT(CASE WHEN ok=1 THEN 1 END)*1./COUNT(1)
FROM TB
WHERE tid=10
/*0.33333333333*/SELECT ltrim(SUM(OK))+
'/'+
ltrim(COUNT(*)) result
FROM table1
WHERE tid = 10
SELECT Convert(varchar(11),SUM(OK))+
'/'+
Convert(varchar(11),COUNT(*)) result
FROM table1
WHERE tid = 10
result
-----------------------
1/3