Hi All,

I have an employee_group table that looks like this:

group_id, employee_id, group_cnt
10, 1, 0
10, 2, 0
20, 3, 0

I want to update the group_cnt column so that it would contain the number of employees in the group. So after the update, the results would look like this:

group_id, employee_id, group_cnt
10, 1, 2
10, 2, 2
20, 3, 1

I've done this type of thing in SQL Server, but the syntax I used doesn't work in Oracle. I'm not sure how to join to the table to update it once I've got my count.

Any help would be greatly appreciated.