advanced SQL

Hello
 I need to write a query that, from this table:

A 3
A 5
B 3
A 9
C 8
B 7

extracts this:

1 A 3
2 A 5
3 A 9
1 B 3
2 B 7
1 C 8

That is, a counter that reset to 1 every time a field changes.

I read a while ago an article on oracle magazine about an advanced sql keyword that could accomplish this, but I've not that paper at hand

Could you please help me ?

Thank-you very much! Received on Mon Jan 13 2003 - 06:56:52 CST