Re: Count number of hits.

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 19 Nov 2002 19:47:14 -0800
Message-ID: <2687bb95.0211191947.a24d164@posting.google.com>

kenneth.osenbroch_at_canaldigital.com (Kenneth Osenbroch) wrote in message news:<9c941a28.0211191127.392a0330_at_posting.google.com>...
> Hi all.
>
> I want to show the number of hits of a certain status from a table.
> The result should be something like this:
>
> Custnr StatusA StatusB StatusC
> 123456 1 0 0
> 123457 0 0 0
> 123458 3 1 0
> 123459 9 2 2
> .
> .
>
> Can anybody help me with this? Any help would be greatly appreciated
> :o)
>
> /Kenneth

Kenneth, look up the decode function in the SQL manual chapter on single row functions and/or the case statement. You could also solve the problem using inline views.

HTH -- Mark D Powell -- Received on Tue Nov 19 2002 - 21:47:14 CST