SELECT t1.azfsmc
AS AZFS,
MIN (TO_CHAR (t1.rq,
'yyyy'))
AS nd,
t1.mxmc,
t1.mj,
MIN (t1.ssje)
AS zx,
MAX (t1.ssje)
AS zd,
TRUNC (AVG (t1.ssje),
2)
AS pjz,
COUNT (
*)
AS sl,
SUM ((
SELECT SUM (ssje)
FROM ywdjb
WHERE zxflag
<> '1')
- (
SELECT SUM (ssje)
FROM ywdjb
WHERE zxflag
= '2'))
AS sr,
(SELECT LYID
FROM lyxxb)
AS DWDM
FROM ywdjb t1, azfs t2
WHERE t1.azfsdm
= t2.azfsdm
AND (t2.stazbz
= '1' OR t2.ltazbz
= '1')
AND t1.zxflag
<> '1'
GROUP BY t1.azfsmc,
t2.nx,
t1.mxmc,
t1.mj;
转载于:https://www.cnblogs.com/siyunianhua/p/5627140.html
相关资源：JAVA上百实例源码以及开源项目
