title: Select all records after a certain column condition is true in sql?
body: <p>Given the following table structure</p>
  
  <pre><code>CustomerID | Balance | Date
        1    |  100.00 | 07-09-2016
        1    |  -50.00 | 08-09-2016
        1    |  -60.00 | 09-09-2016
        1    |  500.00 | 10-09-2016
        1    |  600.00 | 11-09-2016
        1    | -100.00 | 12-09-2016
        1    | -200.00 | 13-09-2016
        1    | -400.00 | 14-09-2016
        1    | -500.00 | 15-09-2016
  </code></pre>
  
  <p>I want to start from bottom and select all rows that has negative balance and stop once credit balance is found. For above example data, I want result to be as below</p>
  
  <pre><code>      1    | -100.00 | 12-09-2016
        1    | -200.00 | 13-09-2016
        1    | -400.00 | 14-09-2016
        1    | -500.00 | 15-09-2016
  </code></pre>
  
  <p>How do I achieve this?</p>
  
  <p>Thanks.</p>