title: Check previous records to update current record in Oracle
body: <p>I'm having difficulty figuring out how to check  Previous records in order to see if the current record should be updated. </p>
  
  <p>Don't want to use the lag function because I will not have the information on how many records to go back. </p>
  
  <p>I have a table that contains Employee Raise information. I want to Put a X in the IND field if there has been a previous Merit increase PCT greater than the current Merit increase within the last 6 months. The current Record is the 2012/05 record.</p>
  
  <pre>
  Emp    Action   Date       Code     proj   PCT   Ind
  ====================================================
  123    raise    2012/01    COL      acct   2
  123    raise    2012/01    Merit    soft   7
  123    raise    2012/02    Merit    Acct   4
  123    Raise    2012/05    merit    soft   6     ?
  </pre>