oracle中where和group by同时使用吗,where语句不允许与group by函数一起使用

0.52

0.01

1

12

预期结果:

1

12

where

一部分但它会回来

group function is not allowed here

to_char((Max(start_time_timestamp+ (2/24))- p.port_statusmoddat), 999.999) >1

我正在处理的查询:

select to_char((Max(start_time_timestamp+ (2/24))- p.port_statusmoddat), 999.999) as Diff

from ZAJBIREJ.UDR_ST r,directory_number d, CONTR_SERVICES_CAP C, MPUSNTAB SN, unicam.vw_contr_imsi_sim x, port p

where reject_reason_code = 'ISUBS'

and r.s_p_port_address = p.port_num (+)

and c.co_id = x.co_id (+)

and s_p_number_address = d.dn_num (+)

and d.dn_id =c.dn_id

AND C.SNCODE = sn.SNCODE

and C.MAIN_DIRNUM = 'X'

and c.cs_deactiv_date is null

and p.port_status = 'd'

AND nvl(C.cs_deactiv_date,'01-jan-2300') = (SELECT MAX(nvl(CA.cs_deactiv_date,'01-jan-2300'))

FROM CONTR_SERVICES_CAP CA, MPUSNTAB SNT

WHERE CA.DN_ID = D.DN_ID

AND SNT.SHDES = SN.SHDES)

group by reject_reason_code ,c.co_id, s_p_number_address,r.s_p_port_address,x.IMSI,p.port_status, p.port_statusmoddat