pl/sql 语句
SELECT fc.cate_no, fd.department_no, fd.department_name, fc.cate_name,
fadep.yymm, SUM (fdh.getcost), SUM (fdh.fixamt), SUM (fdh.rcost),
SUM (fdh.depcost), SUM (fdh.depmon), SUM (fdh.deptot),
SUM (fdh.getcost + fdh.fixamt - fdh.deptot) sum_fdh
FROM fams_document_heads fdh,
fa_cate fc,
fams_department fd,
fa_depreciation fadep
WHERE fc.cate_no = fdh.mainid
AND fdh.ndepid = fd.department_no
AND fdh.newid = fadep.newid
AND fc.cate_no >= NVL (:p_fromcate, fc.cate_no)
AND fc.cate_no <= NVL (:p_tocate, fc.cate_no)
AND fd.department_no >= NVL (:p_fromdep, fd.department_no)
AND fd.department_no <= NVL (:p_todep, fd.department_no)
GROUP BY fc.cate_no,
fc.cate_name,
fadep.yymm,
fd.department_no,
fd.department_name
ORDER BY fc.cate_no
by the way , 如果先写order by ,后写group by 不可以吗
'如果先写order by ,后写group by 不可以吗 '
