求助!大狭~~在线等
SELECT ckhtsp.spbm, MAX(ckhtsp.spzj) AS spzj, MAX(ckhtsp.zwmc) AS zwmc,
MAX(ckhtsp.spgg) AS spgg, SUM(ckhtsp.spsl) AS spsl,
SUM(ckhtsp.spdj) AS spdj, AVG(ckhtsp.spdj / ckhtsp.spsl) AS pjdj,
<<<SUM(ckhtsp.spdj / SUM(ckhtsp.spdj)) AS xsb>>>--->>怎么实现此功能啊
FROM ckht INNER JOIN
ckhtsp ON ckht.hth = ckhtsp.hth
GROUP BY spbm
ORDER BY spbm