title: Include Summation Row with Group By Clause
body: <p><strong>Query:</strong></p>
  
  <pre><code>SELECT aType, SUM(Earnings - Expenses) "Rev"
  FROM aTable
  GROUP BY aType
  ORDER BY aType ASC
  </code></pre>
  
  <p><strong>Results:</strong></p>
  
  <pre><code>| aType | Rev   |
  | ----- | ----- |
  | A     | 20    |
  | B     | 150   |
  | C     | 250   |
  </code></pre>
  
  <p><strong>Question:</strong>
  Is it possible to display a summary row at the bottom such as below by using Sybase syntax within my initial query, or would it have to be a separate query altogether?</p>
  
  <pre><code>| aType | Rev   |
  | ----- | ----- |
  | A     | 20    |
  | B     | 150   |
  | C     | 250   |
  =================
  | All   | 320   |
  </code></pre>
  
  <p>I couldn't get the ROLLUP function from SQL to translate over to Sybase successfully but I'm not sure if there is another way to do this, if at all.</p>
  
  <p>Thanks!</p>