title: How to get minimum date by each records from multiple records
body: <p>I would like to get the minimum date of each record in my table having multiple entry of date with one primary key. Take a look at my table:</p>
  
  <pre><code>   CaseNo     Entry_date   
     ABC-001     2/12/13
     ABC-002     2/09/13
     ABC-001     1/01/13
     ABC-001     1/31/13
     ABC-002     1/01/13
     ABC-003     2/01/12
     ABC-003     2/18/13
  </code></pre>
  
  <p>I want to have this result:</p>
  
  <pre><code>       CaseNo     Entry_date    Min_date
         ABC-001     2/12/13      1/01/13
         ABC-002     2/09/13      1/09/13
         ABC-001     1/01/13      1/01/13
         ABC-001     1/31/13      1/01/13
         ABC-002     1/09/13      1/09/13 
         ABC-003     2/01/12      2/01/13
         ABC-003     2/18/13      2/01/13
  </code></pre>
  
  <p>I want to get the minimum date of each CaseNo recorded on my table.</p>
  
  <p>I tried this code:</p>
  
  <pre><code>Select CaseNo,Entry_date, Min(Entry_date) as Min_date
  from mytable group by CaseNo
  </code></pre>
  
  <p>Result is this:</p>
  
  <pre><code>   CaseNo     Entry_date    Min_date
     ABC-001     1/01/13      1/01/13
     ABC-002     1/09/13      1/09/13 
     ABC-003     2/01/12      2/01/13
  </code></pre>
  
  <p>The code remove the row not having the minimum date. I want to display all records with their minimum date as Min_date.</p>