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:31:54 CDT
