试试这个:
SELECT *
FROM (SELECT *
FROM TableA
WHERE (a + b + c + d > 0)
) tmp
WHERE (cast(a as float) / (a + b + c + d) < 0.08) and e>10
ORDER BY Score DESC
SELECT *
FROM (SELECT *
FROM TableA
WHERE (a + b + c + d > 0)
) tmp
WHERE (cast(a as float) / (a + b + c + d) < 0.08) and e>10
ORDER BY Score DESC
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货