華閱文章網請教SQL查詢并計算總和的語句
select DEPTNO,sum(sal)*(case DEPTNO when 10 then 1.2 when 40 then 1.2 when 20 then 2 when 30 then 1.5 end) as 分類總和
from emp group by DEPTNO
趕緊把分劃到我的帳戶，我答你這個題真不容易，上面的那句是分類總和，下面的是全部的和
測試通過 再不給分 殺了你
select
((select isnull(sum(sal)*1.2,0) from emp where (deptno=10) or (deptno=40) )
+(select isnull(sum(sal)*2,0) from emp where deptno=20 )
+(select isnull(sum(sal)*1.5,0) from emp where deptno=30 ))
SQL語句,統計子查詢的總和
SELECT SUM(STORAGE_IN_PRODUCT_**SCANLOG_*) as PRICE
FROM STORAGE_IN_PRODUCT_M,SCANLOG_M
WHERE STORAGE_IN_PRODUCT_*E_IN_ID = SCANLOG_*E_IN_ID
AND STORAGE_IN_PRODUCT_*T_ID = SCANLOG_*T_ID
不過你這樣合計 是把全表的數據都合計在一起了！~ 應該有一個分組的字段吧？
