Re: ">" in select-Statement

From: stupsnose <swetter_at_arcor.de>
Date: Thu, 21 Jul 2005 10:55:52 +0200
Message-ID: <42df6318$0$16824$9b4e6d93@newsread2.arcor-online.net>

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

Thank you. I don't know how to use CASE in an SELECT-Statement. Can you give me an example? Thanks!

Stefan Received on Thu Jul 21 2005 - 03:55:52 CDT