Number inside SQL Statement like ROWNUM

Hello,

i have a table with the following structure

Primary_KEY
Foreign_KEY_1
Colour

with Data like

PK        FK1        Colour
1            500        blue
2            500        red
3            500        green
4            501        blue
5            501         yellow
6            503        black

i need a result with a number (count) , depending from FK1

PK        FK1        Colour        Number
1            500        blue               1
2            500        red                2
3            500        green             3
4            501        blue               1
5            501         yellow           2
6            503        black             1

Who can help me?

bye
Stephan Received on Wed Mar 06 2002 - 15:49:09 CST