title: How do I get several highest values from a table?
body: <p>I have a table like </p>
  
  <pre><code>id  f1
  --------------
  1   2000-01-01
  1   2001-01-01
  1   2002-01-01
  1   2003-01-01
  </code></pre>
  
  <p>And I want to get say the latest 3 dates in one row</p>
  
  <pre><code>CREATE TABLE Test
  (
    id INT NOT NULL,
    f1 DATETIME NOT NULL,
  )
  
  INSERT INTO Test (id, f1) VALUES (1, '1/1/2000')
  INSERT INTO Test (id, f1) VALUES (1, '1/1/2001')
  INSERT INTO Test (id, f1) VALUES (1, '1/1/2002')
  INSERT INTO Test (id, f1) VALUES (1, '1/1/2003')
  
  SELECT T1.* FROM Test as T1
  </code></pre>
  
  <p>Was trying something like</p>
  
  <pre><code>         SELECT T1.*,T2.* 
             FROM Test AS T1
  LEFT OUTER JOIN Test AS T2 ON T1.id = T2.id AND (T2.f1 &gt; T1.f1)
  </code></pre>