Cross tabulation (matrix) with sql

From: Cees van Drunen <icg_cees_at_euronet.nl>
Date: 15 Sep 1998 17:33:53 GMT
Message-ID: <6tm8e1$d0i@news3.euro.net>

I need to make a cross tabulation (matrix table) with the number of occurences for each set of discrete values of 2 columns, e.g. Table :

col1     col2     value
    1          4        10
    1          4        11
    1          5        12
    2          4        11
    2          5        13
    2          5        15
    2          5        16
    2          6        11
Cross tab:
           4        5        6
---------------------------
1    |    2        1        0
2    |    1        3        1

How can I do that with SQL, taking into account that I don't know the number of levels nor the values of these discrete variables ( col1 and col 2). (If that is known it can be done with the decode function)

Cees van Drunen
icg_cees_at_euronet.nl Received on Tue Sep 15 1998 - 12:33:53 CDT