No auto group by clause for having criteria in Peoplesoft Query
Hello,
I am creating a query which has a having criteria, the having criteria does not automatically add a group by clause like we get when aggregate function is used in the select clause.Thereby my query resuts in " not a GROUP BY expression (50,380)" error.
Kindly let me know how to proceed.
Query :
SELECT A.PRCSINSTANCE, A.PRCSNAME, A.MAINJOBNAME, A.SERVERNAMERUN, A.OPRID, A.RUNCNTLID
FROM PSPRCSRQST A, PSPRCSRQST B
WHERE ( A.RUNSTATUS = '7'
AND A.PRCSINSTANCE = B.PRCSINSTANCE
AND B.PRCSNAME = A.PRCSNAME
AND B.RUNSTATUS = '9')
HAVING ( avg( (( ( to_char( B.ENDDTTM ,'DD'))- (to_char( B.BEGINDTTM ,'DD')))* 24* 60*60) + ( ( ( to_char( B.ENDDTTM ,'HH'))- (to_char( B.BEGINDTTM ,'HH'))) * 60*60) + ((( to_char( B.ENDDTTM ,'MI'))- (