17,377
社区成员
发帖
与我相关
我的任务
分享
SELECT sfb_zddm,
tsxx_sm,
tsxx_dj,
kcb_dbbz * kcb_xbbz jcs,
ddml_mzddm,
kcb_mzddm,
kcb_dbbz,
kcb_xbbz,
kcb_tsbm,
kcb_kcs + kcb_fhs - kcb_fss kfss,
sum(sfb_zds) zds,
sum(sfb_fss) zfss
FROM ddml, kcb, sfb, zdpc, qxhtsbm, tsxxzd
WHERE ddml_mlbh = zdpc_bh
AND sfb_zddm = ddml_zddm
AND tsxx_tsbm = kcb_tsbm
AND sfb_jcd = '370130'
AND kcb_jcd = '370130'
AND ddml_sjdm = qxhtsbm_zdqh || qxhtsbm_zdxh
AND kcb_tsbm = qxhtsbm_tsbm
AND (kcb_kcs + kcb_fhs - kcb_fss) > 0
GROUP BY sfb_zddm,
tsxx_sm,
kcb_kcs,
kcb_fhs,
kcb_fss,
tsxx_dj,
ddml_mzddm,
kcb_mzddm,
kcb_dbbz,
kcb_xbbz,
kcb_tsbm
HAVING SUM(sfb_zds) - SUM(sfb_fss) > 0
ORDER BY zds desc, kcb_tsbm, kfss desc, sfb_zddm;
--select 后面的---sum之前的字段,应和group by的字段保持一致!!!请楼主自已改一下。