title: SQL - select all rows containing account number proceeding an earlier status
body: <p>When an account reaches a specific status, I need to return the account number using a SELECT statement returning any rows with a later date for the same account regardless of the proceeding status.  My table and results will look a bit like this:<a href="http://i.stack.imgur.com/8m69n.png" rel="nofollow">Table and expected results</a></p>
  
  <p>If I were to break down the result set by account number I would need it to look like this.  For account 001 the first time I see B2 I want to see all later rows regardless of status, earlier rows are to be ignored.  I have used this example because B2 is seen again later.  Rows 2,3,4 are returned.</p>
  
  <p>For account 002, there is only one row to be displayed. Row 5 is returned:</p>
  
  <p>For account 003 B2 is the first given status so no previous rows to exclude.  rows 6,7,8 are returned.</p>