select
count(0)
from
(
select
/*+ GROUP_OPT_FLAG(1) */
f.RECORDID as flowid,
rfi.offerid as offerid,
rfi.a00 as A00,
f.flowtypeid as RECORDID,
f.FLOWSERIALID as SERIALNUMBER,
f.APPROVAL_FLAG as APPROVALSTATE,
rfi.FLOWID as recruitFlowId,
rfi.phaseId as phaseId,
case
when f.APPROVAL_FLAG = '1'
and frp.flag = '1' then '待提交'
when f.APPROVAL_FLAG = '1'
and frp.flag = '2' then '待提交'
when f.APPROVAL_FLAG = '2'
and frp.flag = '1' then '待审批'
when f.APPROVAL_FLAG = '2'
and frp.flag = '2' then '审批中'
when f.APPROVAL_FLAG = '2'
and frp.flag = '3' then '审批中'
when f.APPROVAL_FLAG = '2'
and frp.flag = '4' then '审批中'
when f.APPROVAL_FLAG = '3'
and frp.flag = '1' then '待审批'
when f.APPROVAL_FLAG = '3'
and frp.flag = '2' then '审批中'
when f.APPROVAL_FLAG = '3'
and frp.flag = '3' then '审批中'
when f.APPROVAL_FLAG = '3'
and frp.flag = '4' then '审批中'
when f.APPROVAL_FLAG = '4' then '退回'
when f.APPROVAL_FLAG = '5' then '审批通过'
when f.APPROVAL_FLAG = '6' then '审批不通过'
end as STATE,
frp.flag as SERVICESTATEID,
case
frp.flag when '1' then '我的待办'
when '2' then '我的待办'
else '我的已办'
end as SERVICESTATE,
case
sbd.FORMASID when null then f.FLOWID
else sbd.FORMASID
end as FORMASID,
f.FLOWSPONSOR as SPONSOR,
f.FLOWSTARTTIME as LAUNCHTIME,
CONCAT(f.FLOWSPONSOR, '发起', f.FLOWNAME, dm12.dmcpt) as JOBNAME,
f.FLOWTYPE as FLOWTYPE,
dm12.dmcpt as HANDLINGMATTERS,
f.createtime,
ft.FLOW_SIGN_ALIAS as flowalias,
rfi.POSITIONID positionId
from
s_flow_a f
left join FLOW_RUN fr on
f.RECORDID = fr.relation_id
left join rec_offerinfo rfi on
rfi.OFFERID = f.FLOWTYPEID
left join FLOW_RUN_PRCS frp on
frp.RUN_ID = fr.RUN_ID
inner join FLOW_TYPE ft on
ft.SID = fr.FLOW_ID
left join (
select
dmcod,
dmcpt
from
s_codeitemdefine
where
DMGRP = 'S_DM_02') dm12 on
f.FLOWTYPE = dm12.dmcod
left join (
select
FLOWTYPE,
case
ENABLESTATUS when 1 then APPRFORMASID
else WORKFOLWFORMASID
end as FORMASID
from
s_bussiness_driver
where
FUNCTIONTYPE = 'recruit'

and DELETEFLAG = 0) sbd on
sbd.FLOWTYPE = f.FLOWTYPE
where
fr.DEL_FLAG = 0
and f.APPROVAL_FLAG != '1'
and fr.IS_SAVE = 1
and frp.flag in (1, 2, 3, 4)
and frp.suspend = 0
and f.DELETEFLAG = 0
and f.FUNCTIONTYPE = 'recruit'
and f.APPROVAL_FLAG != '4'
and frp.flag in (1, 2)
and f.FLOWTYPE = 'RECRUIT-3'
group by
f.RECORDID,
f.a00,
f.flowtypeid,
f.FLOWSERIALID,
f.APPROVAL_FLAG,
frp.flag,
sbd.FORMASID,
f.FLOWID,
sbd.FORMASID,
f.FLOWSPONSOR,
f.FLOWSTARTTIME,
f.FLOWSPONSOR,
f.FLOWNAME,
dm12.dmcpt,
f.FLOWTYPE,
dm12.dmcpt,
f.createtime,
ft.FLOW_SIGN_ALIAS) table_count

执行失败(语句1)
-4080: 第121 行附近出现错误:
不是 GROUP BY 表达式