title: Get sum of all rows in each row
body: <p>Is it possible to get sum of all rows in each row. Example</p>
  
  <pre><code>Rows | TotalCount
    1  | 20
    2  | 30
    3  | 10
    4  | 60 
  </code></pre>
  
  <p>Now, I want get following result.</p>
  
  <pre><code>    Rows | TotalCount
        1  | 120
        2  | 120
        3  | 120
        4  | 120 
  </code></pre>
  
  <p>If it is possible in SQL server please help.</p>