Max function Group By syntax
Hello all,
Need help with structure of this sql query. How do I write the group by if query contains Max functions?
SELECT
CYCLE_NUM
, SITE_CUSTOMER
,ACCT_ID
,SITE_ADDRESS
,SP_NUMBER
,SP_STATUS
,ANNUAL_CONSUMPTION
,BILL_METER
,(SELECT MAX(MT_DTTM )
FROM D1 DM2 WHERE ) LAST_MANUAL_READ_DATE
,EQUIPMENT
, (CASE WHEN TO_CHAR(substr(data_area, instr(data_area,'<inActiveS',1,1)+12,4)) = 'true' THEN 'True' else 'False' END) AMR_STATUS
,DEVICE_ID
,(SELECT MAX(DM3.MT_DTTM )
FROM D1 DM3 ) LAST_READ_DATE
RUN_DATE
FROM D1_SP_EXMP
LEFT OUTER JOIN
LEFT OUTER JOIN
LEFT OUTER JOIN