title: sql where clause in analytic functions
body: <p>My data look like this:</p>
  
  <pre><code>ADMINDATE ............ NUMVALUE
  14.01.2014 06:08:00 ... 108
  14.01.2014 06:58:00 ... 119
  14.01.2014 07:58:59 ... 116
  14.01.2014 09:00:00 ... 118
  14.01.2014 15:52:00 ... 127
  14.01.2014 17:00:00 ... 123
  *14.01.2014 18:02:59 ... 131
  14.01.2014 18:59:59 ... 125
  14.01.2014 19:59:59 ... 120
  14.01.2014 20:57:59 ... 123
  *14.01.2014 21:59:59 ... 138
  14.01.2014 22:52:59 ... 118
  14.01.2014 23:58:00 ... 117
  15.01.2014 00:33:59 ... 121
  *15.01.2014 01:00:00 ... 140
  15.01.2014 01:25:59 ... 128
  *15.01.2014 02:01:00 ... 143
  15.01.2014 03:00:00 ... 143
  15.01.2014 04:00:00 ... 141
  15.01.2014 08:33:59 ... 153
  </code></pre>
  
  <p>What I want to do is to extract all contiguous time intervals, in which the numvalue is for example less than 130:</p>
  
  <pre><code>14.01.2014 06:08:00 ... 14.01.2014 17:00:00
  14.01.2014 18:59:59 ... 14.01.2014 20:57:59
  14.01.2014 22:52:59 ... 15.01.2014 00:33:59
  15.01.2014 01:25:59 ... 15.01.2014 01:25:59
  </code></pre>
  
  <p>Is there any way to achieve that in SQL. I tried analytic functions, but couldn't solve it.</p>