Hi all

When I execute the query:

SELECT company_parent_id, count(*)
FROM company
GROUP BY company_parent_id;

The result is:


Code:
COMPANY_PARENT_ID       COUNT(*)
-------------------- ----------
1                           303
12                            1
16                            3
21                            1
3                             1
3343                          2
3350                          1
3376                          1
3379                          1
3381                          1
3383                          1
3384                          1
3396                          3
3397                          2
3409                          2
4                             7
9                            19
I need generate a result like following, for each company parent:

Code:
COMPANY_PARENT_ID    GEN
-------------------- ----------
16					 		  1
16							  2
16							  3

3343						  1
3343						  2

4					 		  1
4							  2
4							  3
4							  4
4							  5
4							  6
4							  7
Who can I do this???

thanks!

[]´s