title: How to select row pairs from a large table?
body: <p>In table.....(ID, NAME, EVENT)    </p>
  
  <p>Data:    </p>
  
  <pre><code>(1,BOB,E)    
  (2,JANE,B)    
  (3,JOE,C)    
  (4,TOM,A)   
  (5,JANE,B)    
  (6,JOE,C)    
  (7,BEN,D)    
  (8,TOM,B)    
  (9,JANE,D)    
  (10,JOE,A)    
  (11,JANE,B)    
  (12,BOB,C)    
  (13,JOE,C)    
  .    
  .    
  .
  </code></pre>
  
  <p>Desired Output:    </p>
  
  <pre><code>(2,JANE,B)    
  (3,JOE,C)    
  (5,JANE,B)    
  (6,JOE,C)
  </code></pre>
  
  <p>I'm trying to list out each instance where Jane,B and Joe,C appear in the table consecutively.  Using sqlite.</p>
  
  <p>Any help would be greatly appreciated.</p>