我得到的示例SQL似乎并不能满足我的需求。
大表有400万行,小表有60万行。
/*示例代码:(我是由一位高级分析师提供的) */
SELECT SUM(BigTable.VALUE)
FROM BigTable INNER JOIN SmallTable
WHERE BigTable.ID = SmallTable.ID
AND BigTable.VALUATION_DATE IN
(SELECT MAX(VALUATION_DATE)
FROM BigTable)
GROUP BY BigTable.ID
/*我的代码:(我在内部查询中放置了一个WHERE ) */
SELECT BigTable.ID, SUM(BigTable.VALUE)
FROM BigTable INNER JOIN SmallTable
WHERE BigTable.ID = SmallTable.ID
AND BigTable.VALUATION_DATE IN
(SELECT MAX(VALUATION_DATE)
FROM BigTable INNER JOIN SmallTable
WHERE BigTable.ID = SmallTable.ID)
GROUP BY BigTable.ID
如果ID xyz在最近日期有三个帐户,值分别为$1、$2、$3,我想返回该日期所有帐户的总和: xyz,$6
https://stackoverflow.com/questions/56532141
复制相似问题