oracle sql中( ),ORACLE SQL中的MAX()

我有一个表,用于存储已完成的维护任务的记录列表以及完成它们的日期和时间.我正在尝试执行子查询以提取具有最新日期的每个任务的记录.我的SQL语句是：

SELECT "ENGINEERING_COMPLIANCE"."EO" AS "EO",

"ENGINEERING_COMPLIANCE"."AC" AS "AC",

"ENGINEERING_COMPLIANCE"."PN" AS "PN",

"ENGINEERING_COMPLIANCE"."PN_SN" AS "PN_SN",

"ENGINEERING_COMPLIANCE"."HOURS_RESET" AS "HOURS_RESET",

"ENGINEERING_COMPLIANCE"."MINUTES_RESET" AS "MINUTES_RESET",

"ENGINEERING_COMPLIANCE"."CYCLES_RESET" AS "CYCLES_RESET",

"ENGINEERING_COMPLIANCE"."RESET_DATE" AS "RESET_DATE",

"ENGINEERING_COMPLIANCE"."RESET_HOUR" AS "RESET_HOUR",

"ENGINEERING_COMPLIANCE"."RESET_MINUTE" AS "RESET_MINUTE",

MAX ( "ENGINEERING_COMPLIANCE"."RESET_DATE" ) AS "LAST_COMP_DATE"

FROM ENGINEERING_COMPLIANCE

GROUP BY ( "ENGINEERING_COMPLIANCE"."EO" ) ,

( "ENGINEERING_COMPLIANCE"."AC" ) ,

( "ENGINEERING_COMPLIANCE"."PN" ) ,

( "ENGINEERING_COMPLIANCE"."PN_SN" )

但是我一直收到以下错误：“ORA-00979：不是GROUP BY表达式”

当我删除“GROUP BY”时,我得到：

“ORA-00937：不是单组组功能”

1 – 究竟是什么意思

2 – 声明有什么问题？