Greatest() Inside Decode

[thermidor]

Hi All:

I have the following logic in a query:
DECODE(
GREATEST(AA.qty_shipped, BB.qty_shipped),
AA.qty_shipped, AA.month_1st,
BB.qty_shipped, BB.month_2nd))

What is returned when AA.qty_shipped = BB.qty_shipped?

TIA,
Sven

 

[Turkbear]

Hi,
Probably the first ( AA.Month_1st) but it could also
error out - why not test it and see





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[LKBrwnDBA]

Does not error out, It returns first element that matches.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[Beilstwh]

That is like asking what is greater 72 or 72...The answer is 72.

Bill
Oracle DBA/Developer
New York State, USA