SQL计算问题?在线等
SELECT spbm, SUM(bqje) AS bqje
FROM (SELECT DISTINCT ckhtsp.spbm,
(SELECT isnull(SUM(ckhtsp.spdj * ckhtsp.spsl), 0)
FROM ckhtsp, ckht
WHERE ckhtsp.hth = ckht.hth AND DATENAME(year, htrq) >= '2002-01-01' AND DATENAME(year, htrq) <= '2003-12-01') AS bqje
FROM ckht, ckhtsp
WHERE ckht.hth = ckhtsp.hth AND ckht.hth = ckhtsp.hth
GROUP BY spbm) t
GROUP BY spbm
1,为什么结果是一样的?怎样根据SPBM分组显示数据?
2,前一个日期能不能根据后一个日期相差365天?
谢谢!