title: How to get the highest paid employee row
body: <p>A table consists of employee name, address, phone, department, salary: </p>
  
  <p>How to get the <strong>highest paid employee</strong> row from each department?</p>
  
  <p>I tried with </p>
  
  <pre><code>select dept, max(salary) from employee group by dept
  </code></pre>
  
  <p>but it gives only two columns. But I want to select an entire row. How to do it? </p>
  
  <p>Alternatively how to add more columns to the result?</p>
  
  <p>(I am using SQL Server 2008)</p>