Hard Consult

From: Fabio Oliveira Della Santina <fabio.oliveira_at_edb.ericsson.se>
Date: Mon, 18 Jun 2001 08:14:10 +0300
Message-ID: <3B2D8E22.D27F04F5@edb.ericsson.se>

I have a table with the format below:

ID                        Sev                    Date
---------  --------   --------
ID001                    1                        05-10-2001
ID002                    2                        x
ID003                    4                        x

The range of Sev field is [1..5]

I need to make a consult that generate the output below:

Date/Sev                    1
2                        3                    4                    5
05-01-2001        Count()            Count()            Count()
Count()
12-01-2001                ...
...                        ...

19-01-2001
26-01-2001

The date is grouped by week using the group by clause: GROUP BY (DATE - TO_CHAR(DATE,'D') + 1) Anyboby can help me

Thanks. Received on Mon Jun 18 2001 - 00:14:10 CDT