OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » MAX(DECODE (Oracle 8i, Windows ver 6.1)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

MAX(DECODE [message #676719]

Mon, 08 July 2019 21:56

kumarvk
Messages: 214
Registered: July 2004

Senior Member

Dear Experts,

I am using max(decode like this
MAX(decode(X.CHRG_CODE,'RTAX', X.CHRG_AMT,0)) RTAX,
max(decode(X.CHRG_CODE,'RFEE', X.CHRG_AMT,0)) RFEE,
Apart from RTAX, and RFEE I want to sum other chrg_codes and place it in others. How to do?

Need you expert comments on this.

Report message to a moderator

[Message index]

		MAX(DECODE By: kumarvk on Mon, 08 July 2019 21:56
		Re: MAX(DECODE By: Michel Cadot on Tue, 09 July 2019 00:27
		Re: MAX(DECODE By: kumarvk on Tue, 09 July 2019 01:32
		Re: MAX(DECODE By: kumarvk on Tue, 09 July 2019 01:32
		Re: MAX(DECODE By: Michel Cadot on Tue, 09 July 2019 02:03
		Re: MAX(DECODE By: cookiemonster on Tue, 09 July 2019 04:05
		Re: MAX(DECODE By: GeorgeHenry on Thu, 11 July 2019 03:02
		Re: MAX(DECODE By: cookiemonster on Thu, 11 July 2019 06:03

Previous Topic:	Trying to Report on Date Periods within a table
Next Topic:	Different Values of RAWTOHEX in Oracle 12c and 11g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 19:48:09 CDT 2024