作者maple1221 (无)
看板Database
标题Re: [SQL ] 如何暂存查询结果作为後续的参数使用
时间Wed Sep 18 08:15:28 2013
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