title: How to select first 2 rows using group's
body: <p>I have: </p>
  
  <p><strong>Table1</strong></p>
  
  <pre><code>ID  date       amt
  -------------------    
  001 21/01/2012 1200
  001 25/02/2012 1400
  001 24/03/2012 1500
  001 21/04/2012 1000
  002 21/03/2012 1200
  002 01/01/2012 0500
  002 08/09/2012 1000
  .....
  </code></pre>
  
  <p>I want to select the first two rows from each group of <code>ID</code> ordered by <code>date</code> DESC from <code>Table1</code>.</p>
  
  <p>Query looks like this:</p>
  
  <pre><code>SELECT TOP 2 DATE, ID, AMT FROM TABLE1 GROUP BY ID, AMT --(NOT WORKING)
  </code></pre>
  
  <p>Expected output:</p>
  
  <pre><code>ID  date       amt
  -------------------
  001 21/01/2012 1200
  001 25/02/2012 1400
  002 21/03/2012 1200
  002 01/01/2012 0500
  
  .....
  </code></pre>