title: How to find consecutive rows based on the value of a column?
body: <p>I have some data. I want to group them based on the value of <code>data</code> column. If there are 3 or more consecutive rows that have data bigger than 10, then those rows are what I want. </p>
  
  <p>So for this data:</p>
  
  <pre><code>use tempdb;
  go
  set nocount on;
  
  if object_id('t', 'U') is not null
  drop table t;
  go
  
  create table t
  (
      id int primary key identity,
      [when] datetime,
      data int
  )
  go
  
  insert into t([when], data) values ('20130801', 1);
  insert into t([when], data) values ('20130802', 121);
  insert into t([when], data) values ('20130803', 132);
  insert into t([when], data) values ('20130804', 15);
  insert into t([when], data) values ('20130805', 9);
  insert into t([when], data) values ('20130806', 1435);
  insert into t([when], data) values ('20130807', 143);
  insert into t([when], data) values ('20130808', 18);
  insert into t([when], data) values ('20130809', 19);
  insert into t([when], data) values ('20130810', 1);
  insert into t([when], data) values ('20130811', 1234);
  insert into t([when], data) values ('20130812', 124);
  insert into t([when], data) values ('20130813', 6);
  
  select * from t;
  </code></pre>
  
  <p>What I want is:</p>
  
  <pre><code>id          when                    data       
  ----------- ----------------------- -----------
  2           2013-08-02 00:00:00.000 121        
  3           2013-08-03 00:00:00.000 132        
  4           2013-08-04 00:00:00.000 15         
  6           2013-08-06 00:00:00.000 1435       
  7           2013-08-07 00:00:00.000 143        
  8           2013-08-08 00:00:00.000 18         
  9           2013-08-09 00:00:00.000 19    
  </code></pre>
  
  <p>How to do that?</p>