select sum(case when NUM>12 then NUM else 0 end) moresum, sum(case when NUM<12 then NUM else 0 end) lesssum from t;
补充一下 我的Time字段 是唯一的 截图重复的那个不用管
SELECT SUM(COL) FROM (SELECT TOP 5 COL FROM TB WHERE COL<12 ORDER BY COL DESC) T SELECT SUM(COL) FROM (SELECT TOP 5 COL FROM TB WHERE COL>12 ORDER BY COL ) T
select sum(case when NUM>12 then NUM else 0 end) moresum,
sum(case when NUM<12 then NUM else 0 end) lesssum
from t;
SELECT SUM(COL) FROM (SELECT TOP 5 COL FROM TB WHERE COL>12 ORDER BY COL ) T