select distinct column field and total sum for it in mysql

Question

i have following table:

topic_id(unique)  forum_id   forum_views

1002                1885         5
1003                1893         2
1004                1885         3
1005                1892         6

How can i get output like this: (unique forum_id with total forum views from above table)

forum_id    forum_views
1885           8
1893           2
1892           6

ANY HELP IS APPRECIATED.

This is what i am trying:

select distinct forum_id, sum(topic_views) from table_name

Answer 1

select forum_id, 
       sum(forum_views) as forum_views
from jforum_topics
group by forum_id

Answer 2

Use this query select forum_id, sum(distinct forum_views) from table group by forum_id;

In this query sum distinct will do the sum of distinct value and do the grouping by the desired column.

If you want sum of all the values irrespective of distinctness then simply use sum(forum_views).