title: SQL query to find out of order records
body: <p>I have a PHP program w/MySQL database which contains many records.  Two columns of particular relevance are incidentnumber and date.  These both move forward only.  However, sometimes a user enters data which is out of sequence; eg:</p>
  
  <pre><code>Incident Date
  1        Jan 1 2000
  2        Jan 1 2010
  3        Jan 1 2002
  </code></pre>
  
  <p>It appears that incident 2 was entered with the wrong date, it should be Jan 1 2001.</p>
  
  <p>Is there any way to query for records where the date is out of sequence?  Or do I have to iterate through all records tracking last date to find the error?</p>
  
  <p>ADDED NOTE: The incidents are not sequential (they might go 1,3,6,123, etc).  Nor are the dates sequential.  And these are columns in the same table.</p>