title: Get MAX and MIN values along with their row id?
body: <p>I have a table similar to the following</p>
  
  <pre>
  ID   | temp_hi | temp_lo
  ------------------------
    0  |    72   |   38
  ------------------------
    1  |    56   |   33
  ------------------------
    2  |    67   |   28
  </pre>
  
  <p>Is there a way in a single SQL statement to grab the MAX(temp_hi) and it's ID and get the MIN(temp_lo) and it's ID?  So in this case it would be:</p>
  
  <pre><code>(temp_hi id) 0, (temp_hi) 72, (temp_lo id) 2, (temp_low) 28 
  </code></pre>