title: SQL Query to get the Sum of all column values in the last row of a resultset along with row sum (group by)
body: <p>Can someone please help me to write a query to obtain the TCS and TRS?</p>
  
  <pre><code>ID  Jan Feb Mar TRS
  1   4   5   6   15
  2   5   5   5   15
  3   1   1   1   3
  TCS 10  11  12  
  </code></pre>
  
  <p>Both TCS (Total Column Sum) and TRS (Total Row Sum) are new column and row respectively which gives their.</p>