title: How to get average for a column value in sql server
body: <p>I want to get average for a column </p>
  
  <p>Name        Salary</p>
  
  <p>HI         33168,00</p>
  
  <p>Hello      32882,00</p>
  
  <p>When I tried with below query </p>
  
  <pre><code> select Name, Salary, Avg(Salary) as avg from table group by name, Salary
  </code></pre>
  
  <p>I'm getting Salary and Avg salary both same value.</p>
  
  <p>expected result:</p>
  
  <pre><code>       Name         Salary       
  
          HI          33168,00    
  
          Hello       32882,00         
  
          avg         33025,00 
  </code></pre>