title: Display only one row for values that appear multiple times
body: <p>I have multiple rows with the same name in this table, and I want to show only one of row of each. For example, with the following data:</p>
  
  <pre><code>| name | number |
  +------+--------+
  | exe  |   1    |
  | exe  |   10   |
  | exe  |   2    |
  | bat  |   1    |
  | exe  |   3    |
  | bat  |   4    |
  </code></pre>
  
  <p>I would like to see the following results:</p>
  
  <pre><code>| name | number | 
  +------+--------+
  | exe  |  16    |
  | bat  |  5     |
  </code></pre>
  
  <p>How can I achieve this result?</p>
  
  <p>Duplicate response: My question only have 1 table, the JOIN ..ON command creates confusion in understanding, i think this simple question can help many guys!</p>