title: get values before certain date in sql
body: <p>i have one question about get multi rows before the date getting infection:</p>
  
  <pre><code>patientID   Appt_reason dateofProcedure
  1                        1/2/2016
  1                        1/3/2016
  1             infectoin  1/4/2016
  2                        3/1/2016
  2                        3/3/2016
  3                        3/4/2016
  3             infectoin  3/5/2016
  3                        3/6/2016
  3                        3/7/2016
  5                        2/2/2016
  5             infectoin  2/3/2016
  5                        2/4/2016   
  </code></pre>
  
  <p>I need to get rows like this</p>
  
  <pre><code>patientID   Appt_reason dateofProcedure
  1                       1/2/2016
  1                       1/3/2016
  1          infectoin    1/4/2016
  3                       3/4/2016
  3          infectoin    3/5/2016
  5                       2/2/2016
  5          infectoin    2/3/2016
  </code></pre>
  
  <p>anybody know the answer? thanks</p>