Re: [SQL ] 如何暫存查詢結果作為後續的參數使用

[maple1221 (無)]

MS SQL 寫法，請試看看

SELECT Customer ,
    1.0 * SUM(Amount) / NULLIF((SELECT SUM(Amount) FROM TableName),0)
FROM TableName
GROUP BY Customer

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 118.163.158.7