title: query 1st, 2nd, 3rd place with tie break using 2nd and 3rd lowest with each time on one row
body: <p>I am trying to get the top three fastest by ID and if there is a tie to use the 2nd and 3rd fastest times as a tie break. So in the example below 3 and 5 tied for the third fastest times but 3 has the 2nd fastest time between the two.</p>
  
  <p>Preferably the results would show the 1st, 2nd and 3rd times for each id and be ordered by the 1st fastest followed by the 2nd and then 3rd fastest for each ID.</p>
  
  <p>So the table looks like this:</p>
  
  <pre><code> ID | TIME
  ----|-------  
   1  |  6.45  
   2  |  12.43  
   1  |  4.52  
   4  |  16.24  
   5  |  9.43  
   2  |  10.46  
   2  |  8.46  
   3  |  17.49  
   4  |  20.46  
   3  |  16.49  
   5  |  16.97  
   3  |  9.43  
   1  |  25.77  
  </code></pre>
  
  <p>I am hitting a wall trying to get the correct result all in one query..</p>
  
  <p>Desired output would look something like: </p>
  
  <pre><code> ID | lowest time | 2nd lowest | 3rd lowest
  ----|-------------|------------|------------ 
   1  |  4.25       | 6.45       | 25.77  
   2  |  8.46       | 10.46      | 12.43  
   3  |  9.43       | 16.49      | 17.49
   5  |  9.43       | 16.97      |   
  </code></pre>