SELECT CODE,PROV_CODE,DEPART ,count(*) FROM (
SELECT --count(c.CODE||c.PROV_CODE||c.DEPART ),
c.CODE,c.PROV_CODE, c.DEPART,c.COST,nvl(t.RATE,0), c.JYFS, c.PRICE,c.IN_TAX,c.PRICE,0,c.PRICE,p.TAX_TYPE,'正常','1', c.CONT_CODE, 0, substr(c.DEPART,0,4)
FROM CUR_STOCK c LEFT JOIN CONT_LIST t ON c.CONT_CODE =t.CODE
LEFT JOIN PROV_LIST p ON c.PROV_CODE = p.CODE
GROUP BY c.CODE,c.BARCODE,c.DEPART,c.JYFS,c.PROV_CODE,c.COST,c.PRICE,c.CONT_CODE,c.IN_TAX,t.RATE,p.TAX_TYPE
)k
GROUP BY CODE,PROV_CODE,DEPART