Re: A newbie query

From: <fitzjarrell_at_cox.net>
Date: Thu, 02 Aug 2007 13:50:37 -0700
Message-ID: <1186087837.416370.294060@d30g2000prg.googlegroups.com>

On Aug 2, 3:33 pm, "dn.p..._at_gmail.com" <dn.p..._at_gmail.com> wrote:
> I have a table t1(name, value).
> The entries are (a1, 40), (a2, 233), (a3, 22).
>
> Is it possible to write a query which tells me whether the value is
> above/below 100.
>
> The output should be :
>
> Name Value Comparison
> ---------------------------------------------------
>
> a1 40 Below
> a2 233 Above
> a3 22 Below
>
> Thanks in advance.

Yes. Look up CASE in the documentation at tahiti.oracle.com, or peruse the examples at www.psoug.org/library.html.

David Fitzjarrell Received on Thu Aug 02 2007 - 15:50:37 CDT