title: SQL : get Min and Max value in one column
body: <p>I have an <code>employee</code> table with a name and a salary.</p>
  
  <p>I want to print these 2 columns with only 2 records in them, the name of my highest and lowest payed employee.</p>
  
  <p>It should look something like this:</p>
  
  <pre><code>Name      Salary  
  ------------------
  James       800  
  Samanth    3000
  </code></pre>
  
  <p>The following code is NOT what I want, I want the min and the max in 2 columns with 2 names representing each value</p>
  
  <pre><code>SELECT 
      name, MIN(salary), MAX(salary)
  FROM
      employee
  </code></pre>