title: Sql select statement while getting total of one value
body: <p>Hi I have following select statement </p>
  
  <pre><code>      select
        a.amount
        ,b.des
        ,a.id
        ,SUM(a.amount) as total
        ,b.id  
        from t_sales a
        left outer join t_location b on(b.id=a.orgId)
        where a.Id=@salesId   and
        a.sId=@supId
        GROUP BY a.amount, b.des, a.Id,b.id;
  </code></pre>
  
  <p>Everything is working fine, except total. I am trying to get total of a.amount which is returning 15 values so I want to have total of all 15 values. Please let me know how to fix it. 
  Thanks </p>