Re: ">" in select-Statement

From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Thu, 21 Jul 2005 11:11:56 +0200
Message-ID: <42df67df$0$16777$9b4e6d93@newsread4.arcor-online.net>

stupsnose schrieb:
> Maxim Demenko schrieb:
>

>> stupsnose schrieb:
>>
>>> Hello!
>>>
>>> I wonder if i can use something like
>>> SELECT DECODE(a>b,0,1) FROM dual;
>>> to check if a is greater then b? Can someone help me please?
>>>
>>> Thank you!
>>> Stefan
>>
>>
>>
>> The simpliest approach would be to code that with a CASE - you can 
>> directly compare the values. If you must use decode however, it could be:
>>
>> Best regards
>>
>> Maxim

>
>
> Hello!
>
> I tried the CASE-thing. It works for normal SELECTs. But i cannot get it
> to work with GROUP BY. If i use SELECT max(CASE... END "testit") FROM...
> i get an Oracle Error ORA-00907. Can yoyu help me with that?
>
> Thanks!
> Stefan

Please , remove that "testit" from your expression.

Best regards

Maxim Received on Thu Jul 21 2005 - 04:11:56 CDT