The MAX() function will do it ...

Code:
select
   forum_id,
   Max(group_view) group_view,
   Max(group_read) group_read,
   Max(group_post) group_post,
   ...
Where
   group_id = 2
Group By
   forum_id
... for example