title: How to select all records after a certain record within groups in sql?
body: <p>Given the following table structure</p>
  
  <pre><code>Col1, Col2, EventType,  DateTime
  </code></pre>
  
  <p>How can I select the records per grouping of <code>Col1</code>, <code>Col2</code> that occur after the top record where <code>EventType = 3</code> for that particular group of <code>Col1</code>, <code>Col2</code>.</p>
  
  <p>For example with the following data </p>
  
  <pre><code>Col1, Col2, EventType, DateTime
  A       B       1      2012-1-1
  A       B       3      2011-1-1
  A       B       1      2010-1-1
  C       D       1      2012-1-1
  C       D       2      2011-1-1
  C       D       2      2010-1-1
  C       D       3      2009-1-1
  C       D       2      2008-1-1
  C       D       3      2007-1-1
  C       D       1      2006-1-1
  C       D       2      2005-1-1
  </code></pre>
  
  <p>I want to select</p>
  
  <pre><code>Col1, Col2, EventType, DateTime
  A       B       1      2012-1-1
  
  C       D       1      2012-1-1
  C       D       2      2011-1-1
  C       D       2      2010-1-1
  </code></pre>