Re: DECODE

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Fri, 4 Feb 2000 06:59:42 +0100
Message-ID: <949644112.1877.0.pluto.d4ee154e@news.demon.nl>

No, but decode can.
Just copy and paste?

Hth,

--
Sybrand Bakker, Oracle DBA
Chua Boon Yiang <chuaby_at_hotmail.com> wrote in message news:87do47$k2t$1_at_newton.pacific.net.sg...
> Hi,
> in the statement :
> select
> DECODE (deptno,10, 'ACCOUNTING',
> 20, 'RESEARCH',
> 30, 'OPERATION',
> 40, 'OPERATION',
> 'NONE')
> count(*) from tableA
> group by deptno
>
> is there anyway for me to group by the decoded values rather than
> the original stored values ?
> eg i have 2 diff dept numbers, but i want to group them as 1 dept,
> using the above statement, there will be 2 rows of OPERATION.
> col alias cannot be used in the group by.
>
> Thanks
> Boon Yiang
>
>
Received on Thu Feb 03 2000 - 23:59:42 CST