在我的sql中使用Distinct和Sum

Question

below is the table i have created, my goal is to remove the duplicate results then add the value up.

|  username   |   value
|    Bobby    |     5
|    Bobby    |     5
|    Bobby    |     7

This is the result I am looking for

|  username   |   value
|    Bobby    |     12

How can I achieve this?

Answer 1

SELECT SUM(DISTINCT value) FROM TableName Group By UserName