SQL grouping continous records

Hi all,

I want to group continous records
I have the following records:

col1 col2

1     A
2     A        
3     B
4     A
5     C
6     C
7     A
8     A

The following table represent what i want: Count(col2) col2

2            A
1            B
1            A
2            C
2            A

Do you know a solution in SQL???

Thx
Peter Received on Tue Feb 11 2003 - 10:55:00 CST