title: SELECT statement to get sum of grouped columns with column header
body: <p>Table data:</p>
  
  <pre><code>NAME     RS
  A        10
  A        20
  A        30
  B        15 
  B        5
  B        10
  C        70
  C        30 
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>A   -- column name
  10
  20
  30
  60  -- total of A
  
  B
  15
  5
  10 
  30  -- total of B
  
  C
  70
  30
  100 -- total of C
  </code></pre>
  
  <p>So far I have tried:</p>
  
  <ol>
  <li><code>UNION ALL</code></li>
  <li>Select all datas and manipulated with front end.</li>
  </ol>
  
  <p>Is there any other easiest solution without <code>UNION ALL</code>?</p>