PL/SQL (MOSC)

MOSC Banner

Max function Group By syntax

in PL/SQL (MOSC) 1 commentAnswered

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 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center