-
Update Help
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|